I have to compare two sheets for changes
 

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

I have to compare two sheets for changes
 

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:

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

I have to compare two sheets for changes
 

My utility, Workbook Compare, can do this.

--
Regards,
Tim Zych
http://www.higherdata.com
Workbook Compare - Excel data comparison utility

"vqthomf" wrote in message
...
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