Recent content by maximas

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.