Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare row contents to baseline data
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare row contents to baseline data
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare row contents to baseline data
Let me know if I can be of help. Otto
"Ladymuck" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare Contents of 2 listboxes | Excel Programming | |||
Compare row contents | Excel Programming | |||
compare the contents of one range of cells with the contents of a. | Excel Discussion (Misc queries) | |||
compare cell contents | Excel Worksheet Functions | |||
How to compare the contents of two rows is the same? | Excel Programming |