Compare worksheets help sought

[Jak]

Tomorrrow I have to compare two worksheets. One from a client, the other from our database. The idea is to identify matching data and the differences between the two spreadsheets! Can anyone recomend a comparison program that can allow me to specify the range and highlight the two criterias to a new worksheet? Any suggestions or links to programs would be welcomed. Thanks

 

[Nimrod]

Hello Jak:
What are the 2 sheet names ?
What columns do you need to compare ?
What results would you like to see ?

 

[Jak]

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.

 

[Jak]

Trying out a programe called Synkronizer XL 8.0 to accomplish this.

Thanks all for the input.

 

[Nimrod]

Trying out a programe called Synkronizer XL 8.0 to accomplish this.

OK Jak... I won't work on this problem unless you post back indicating the the Synkronizer wasn't successful. :wink:

 

[Jak]

No problem Nimrod, got the data late yesterday afternoon and time is of the essence so I will be trying out the programe today to see if it idenfifies all the differences. If it falls short I will be sure to ask for your help. Many thanks

 

[Jak]

Just a quick thank to Nimrod for the offer of help. Got sorted yesterday using the aformentioned program.

If anyone runs into a similar situation, try the evaluation version which can be downloaded at:

http://www.synkronizer.com/

Jak