I have to compare two sheets for changes

V

vqthomf

Hi I have to try and compare 2 sheets and highlight the cahnges, what is the
best way of doing this in VBA, I was going to try and do it cell by cell but
I was wondering if there was a quicker way?. Any help would be much
appreciated.
Regards
Charles
 
S

Stefi

Maybe you can make use of conditional formatting, e.g. if you want to compare
newsheet to oldsheet which is an earlier version of newsheet, then apply CF
on newsheet! Select A1 then select used range on newsheet and create CF with
formula =A1<>oldsheet!A1
Choose a pattern and press OK!
--
Regards!
Stefi



„vqthomf†ezt írta:
 

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

comparing two columns in vba 2
Excel file compare (each sheet). Is there something already available?. 2
Comparing two workbooks - Excel 2010 - not using Add-ins 2
comparing strings 6
compare value of cell in one sheet to range of another sheet 3
Comparing two worksheets and highlight unmatched Data 0
Compare two workbooks and hi-light matches 0
Compare two worksheets in the same workbook and highlight difference 7

Top