Hi Nimrod
The data will be placed into one workbook. Sheet 1 will have the client’s data; sheet 2 will have our data. I need to compare our data to the clients to see where there are anomalies.
I have been thinking about this and what I need to do is use two colour highlights, the first to highlight cells which are the same and the second to highlight cells that are different on Sheet 1 & Sheet 2. I can then extract rows from both sheets where anomalies have been flagged and compare the differences.
Columns 1 through 8 are to be tested and there are over 5500 rows on each sheet. There is a header row with the following headings on each sheet.
batch, cand no, forename, surname, product, portfolio, ext, status
I am going to sort each worksheet by batch, surname, product but the number of rows on each sheet is likely to be different.
There is a lot of data to compare and the very thought of how much time it will take worries me. Thanks for your interest Nimrod, greatly appreciated.
If you need any additional info, let me know. Thanks.