Compare Two Worksheets and Highlight Changes

T

TEAM

I have a workbook where sheet 1 and sheet 2 have the same basic
information, but sheet 2 is the most up to date version. Is there
simple macro to compare the data in each sheet and highlight the cells
in sheet 2 that changed?

Thank you!
 
T

TEAM

Any ideas on this one? I really need some help. Is there a way to do
it using VLookup?


Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
VBA Coding Help for Beginner 0
Excel for comparing two columns exceeding 1,048,576 count 3
comparing two columns in vba 2
Comparing two workbooks - Excel 2010 - not using Add-ins 2
Conditional Formatting to Compare Two Sheets of Data 1
Compare two worksheets in the same workbook and highlight difference 7
Macro to Combine Data from Multiple Sheets with Cell References 4

Top