Comparing data in 2 sheets

[asolanki]

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]

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]

This shareware product is awesome


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