Compare row contents to baseline data

[Ladymuck]

I have a source data spreadsheet consisting of 68 columns and about 10000+
rows. The unique identifier is in Column Q (not my design!). I'll call this
sheet (Source). Headers are in row 1.

I receive updates to the data in the form of a spreadsheet containing a
subset of Source with the columns in a defined format that matches Source,
and I need to perform a number of validation and comparison checks before
accepting these updates (lets call this sheet Update).

I would like to take the ID (say in Q2) from Update and check if it exists
in Source. If it does, I would then like to compare the entire row from
Update to see if it matches the corresponding row in Source. If there is a
mismatch, I would like the cell in Update to be shaded and a log (eg on a new
worksheet) detailing the ID, the Source value, the Update value and the
header row value.

I'm thinking that loading the row into an array would be the most efficient
and doing a loop to check each row in the Update sheet. However, I'm having
trouble getting started and would appreciate some pointers in the right
direction.

Thanks for your help. Please ask if you need anything clarified.

 

[Otto Moehrbach]

Ladymuck
What do you want to do if the ID cannot be found in Source?
I would do a loop through all the rows in Column Q, then do a loop
through all the cells in each row to look for differences. If you wish,
send me your file or a small sample of it and I'll work up some code for
you. Fake the data if you wish, I need just the layout of the data.
Include a couple examples of what you want including the layout of the log
sheet. Also include the text of your original post and the version of Excel
you are using. My email is (e-mail address removed). Remove the
"extra" from this email address. HTH Otto

 

[Ladymuck]

Otto,

Thanks for your reply. I realised I was asking a bit much and have managed
to get a good start after a late night and much research. I am working on
similar lines to your suggestion, which is reassuring!

Kind regards
Louise

 

[Otto Moehrbach]

Let me know if I can be of help. Otto