Compare worksheets help sought

Jak

Well-known Member
Joined
Apr 5, 2002
Messages
807
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
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Nimrod

MrExcel MVP
Joined
Apr 29, 2002
Messages
6,259
Hello Jak:
What are the 2 sheet names ?
What columns do you need to compare ?
What results would you like to see ?
 

Jak

Well-known Member
Joined
Apr 5, 2002
Messages
807
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

Well-known Member
Joined
Apr 5, 2002
Messages
807
Trying out a programe called Synkronizer XL 8.0 to accomplish this.

Thanks all for the input.
 

Nimrod

MrExcel MVP
Joined
Apr 29, 2002
Messages
6,259

ADVERTISEMENT

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

Well-known Member
Joined
Apr 5, 2002
Messages
807
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

Well-known Member
Joined
Apr 5, 2002
Messages
807
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,323
Messages
5,571,544
Members
412,402
Latest member
xam99
Top