Compare Excel Sheets

eiyengars
eiyengars used Ask the Experts™
on
Want to compare two sheets and highlight the difference... Every week the data from sheet 2 changes and may have a different sort order.. I want to highlight any difference between the two sheets...




Data is similar to the link below:

http://filedb.experts-exchange.com/incoming/2012/03_w13/564010/Compare-example.JPG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
HuaMin ChenProblem resolver

Commented:
Hi,
You have to loop through Sheet 1. For every row, you find out the relevant row in Sheet 2 and list out the difference of two rows after the comparison.

Author

Commented:
Is there a vba script to perform this ?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Thanks for the link...but is there a formula or vba solution to do this? the list on the link is exhaustive.
HuaMin ChenProblem resolver

Commented:
You need to loop through 1st list first, to do the comparison on 2 lists.
Microsoft Excel Expert
Top Expert 2014
Commented:
@eiyengars

i have had answered similar questions countless of times.

please see the VBA solution attached.   also more different ways for different files see my answer in this link


in addition, if your data is not aligned and sorted, then there is a commerial add-in which one of its feature does the alignments of rows. you can have a look into the example and you may try a trial copy from link

if you have excel 2013, then there is a free included feature of compare , see it here

when it comes to excel comparison, no other software can beat the Excel synkronizer. it is the best commercial cheap(onetime payment) software that is very useful. you can test it with download trial of it.  from here  it also aligns, compares, merged and have tons of best features.
Comparator.xlsm

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial