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.

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 Removed). Remove the
"extra" from this email address. HTH Otto

"Ladymuck" <(E-Mail Removed)> wrote in message
news:E034CC55-E4D8-4EB9-98DA-(E-Mail Removed)...
> 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,

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

Let me know if I can be of help. Otto

"Ladymuck" <(E-Mail Removed)> wrote in message
news:9818A720-5833-4AB1-8F82-(E-Mail Removed)...
> 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