Compare worksheets help sought

Jak

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

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

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
825
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
825
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
825
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
825
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,052
Messages
5,835,146
Members
430,342
Latest member
Sailingexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top