Hi, I have a problem. I have 12 spreadsheets, all in one workbook. Each sheet has the same number of rows and columns. I want to compare the value in Column 9, sheet 1, with the value in Column 9, sheet 12. If 9 in sheet 1 is greater than 9 in sheet 12, replace row in sheet 12 with row from sheet 1.

Something like:

For a = 1 to 1003:

If Value in Col. 9, row a, sheet 1 > Value in Col. 9, row a, sheet 12,
copy/replace row a from sheet 1 to row a, sheet 12
End if

Next a

I don't know the specific Excel commands or syntax to make this work. I want to then run the macro on the 11 original spreadsheets, giving me a sheet 12 that has all of the rows in each sheet with the largest value in Column 9.

I used to understand how to do this sort of thing in the older versions of excel (1998), but they seem to have changed or removed a bunch of functions. There may be an even easier way that doesn't involve a macro, but I'm at a loss to figure out what it might be.

Thanks in advance for any help I can get.

FH