Comparing data in 2 sheets

asolanki · Jul 9, 2003

Hi

I wonder if anyone can help me?

I want to create some code that will take two Excel Sheets and compares the data in both sheets, highlighting the data that is different on the sheet

The columns will be the same but the Rows may be in a different order while comparing the data

Can this be done easiliy?
any tips on how to do it?

Thanks for you help as always

Ash

plettieri · Jul 9, 2003

Hi:

You might try looking at what was suggested here, its similar.

http://www.mrexcel.com/board2/viewtopic.php?t=42371&postdays=0&postorder=asc&start=0

You also can use the search feature ...search on "compare workseets" and press the "search for all items" button. There is a lot to look at here.

hope this helps

plettieri

kathleen · Jul 9, 2003

This shareware product is awesome

http://www.synkronizer.com/e/infos.html - Examples
http://www.synkronizer.com/e/shareware.html - Download

Comparing data in 2 sheets

asolanki

Board Regular

Excel Facts

plettieri

Well-known Member

kathleen

Active Member

Similar threads

Forum statistics

Share this page

Comparing data in 2 sheets

asolanki

Board Regular

Excel Facts

plettieri

Well-known Member

kathleen

Active Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock