Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare two Sheets | Excel Programming | |||
Compare sheets | Excel Programming | |||
Compare 2 sheets | Excel Discussion (Misc queries) | |||
Compare Sheets | Excel Discussion (Misc queries) | |||
Compare Sheets | Excel Discussion (Misc queries) |