Search results for query: *

I look and all formulas from excel are from seconds to hrs and mins. Is there any excel formula for HH:MM to Secs. ex. 1:00 = 360 seconds Thanks,

i try using the codes in thread707-501812 but somehow did get it correct. how would you rewrite it for 3 sheets comparing each other and then output it to sheet4. I use the column one as my main comparison for all 3 sheets.

don't anyone have a vba code like loop tru table 1 get data, then compare to table 2, then use the result to compare to table 3 for the final table?

how would you write that in a vba excel macro?

any sugestions will be greatly appreciated

I have 3 sheets with 4 columns that is the same, but the data on 3 other column might or might not be the same. i need to combine all 3 sheets into 1 sheet. here is the data! sheet 1 sheet 2 id# | name | month | amt id# | name | month | amt 123 | jay |200601 | 2 111 |...

Thank you! And all this time I'm trying to loop thru the spreadsheet. I'll try and post the result. thanks for the help.

I'm calculate the sum only if the id#'s match each other.

how can there be no VBA is you need to compare the data col1 | col2 | col3 id# | Amt1 | Amt2 1 | 1 | 1 1 | 2 | 1 1 | 1 | 2 2 | 2 | 1 3 | -2 | -1 <- negative amt 1 | -1 | -1 <- negative amt 2 | 2 | 2 3 | 3 | 1 4 | 1 | 1 id# | total 1...

I'm trying to sum up the amounts only if the id# is the same. how can I do that? here is the data. col1 col2 col3 id# Amt1 | Amt2 1 1 | 1 1 2 | 1 1 1 | 2 2 2 | 1 3 -2 | -1 <- negative amt 1 -1 | -1 <- negative amt 2 2 | 2...

HEY Zathras: The script you gave me is not a batch script, it's a cobol script. and it doesn't work. I need a batch script, that I can run with a single click without any software. Here an idea! how about write a batch script that will open the text file in excel and run a macro that will...

thanks Zathras! I'll try it out! post the result later!

it's a continuous line, ie. one character after another. ie. 1234567890!908405802384502!812380481083!9080890832323 where the exclamation mark is one record. I want to use the exclamation mark as the line break. how can I do that in a batch file. p.s about 2000 records in a line, but since...

hello: I have a text file will continuous line without any line breaks with a box as a exclamation as a divider, ie. abcde!abced!abcde. Could I write a batch file that will open the text file and then loop thru the line and if there is an exclamation put a line break there? Any help will be...

I have a unix file and want to write a batch file that will convert the unix file to a windows file format, so I can open it in windows. Any help will be great.

Hi: I have 2 tables, A and B table A have 3 columns A1, B1, C1 table B have 3 columns C1, D1, E1 select A.A1, A.B1, set B.C1 = A.C1, A.D1, A.E1. from A, B where A.A1 = C.D1. how could I set the third column to table B instead of records from table A. I'm trying to get all the records from...

I have a worksheet, but I want only parts of the worksheet be able to add or delete rows. If I select the cell(1,1) the user can use macro to insert line. If I select (5,1) the user can not use macro to insert line . Example: A B C D E 1 2 3 4...

This will work if your spreadsheet if it is not protected, but my sheet is protect. Here is the macro to add and delete a line, but I want to make sure that the selection where they want to insert is not in the protected range. here is the code: ActiveSheet.Unprotect Password:=&quot;test&quot...

I have a worksheet, but I want only parts of the worksheet be able to add or delete rows. for example: A B C D E 1 2 3 4 protected from adding or deleting this row 5 protected from adding or deleting this row 6 protected from adding or deleting...

i have a saveas macro and when the user click the macro to run it, it will save a new file with the name provided and put in the same location, but file always save under my documents in my computer. ActiveWorkbook.SaveAs FileName:= _ finalname & &quot;.xls&quot;, FileFormat:=xlNormal...