Comparing 2 spreadsheets
 

You could certainly loop through one range/sheet and for each row, compare
it to the rows in the second range/worksheet.

You requirement doesn't make a lot of sense, however. You say if you find
a match between IMG and Config, then copy the matched row from config to
IMG. this would put two copies of that row in IMG, since you are copying
row that matches.

Also, it is unclear what constitutes a match. Is there a single column that
is compared or must the match occur across all the columns from D to L for a
given row? If the row is copied, where is it placed in IMG - at the
Bottom?

Regards,
Tom Ogilvy

Charlene wrote in message
...
I have 2 worksheets... One (config) consisting of old
data and a second (IMG) spreadsheet consisting of old and
new data. I would like to take the spreadsheet 'config'
with range (D9:L509) and match up with 'IMG' range
(D9:L443). If the cells within the match up between the 2
worksheets I would like the row in 'config' to be pasted
into 'IMG'. I have used the compare from
http://www.cpearson.com but that is doing rows
sequentical. That would be great expect the IMG file has
rows added that the config file dosent have....

Please let me know what can be done... VBA, macro, etc??

Hope this makes sense.
Thanks in advance for the help!!
Charlene