eiyengars
asked on
Compare Excel Sheets
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
Data is similar to the link below:
http://filedb.experts-exchange.com/incoming/2012/03_w13/564010/Compare-example.JPG
Last Comment
ASKER
Is there a vba script to perform this ?
ASKER
Thanks for the link...but is there a formula or vba solution to do this? the list on the link is exhaustive.
You need to loop through 1st list first, to do the comparison on 2 lists.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Visual Basic Classic
Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.
165K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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.