M
mark
Hello everyone,
I have been reading this group for a while, however I am quite a
rookie in using of excel. I would appreciate if someone could help
with this issue.
I quite often have to compare two sheets (from different
workbooks-files, but with the same sheet name). Calculations are thus
updated time by time and I need to check where were the main
differences. Cells contain both values and formulas. I have found
through this newsgroup nice add-ins of Myrna Larson and Bill Manville,
and Rob Bruce. However I would need the macros to highlight only
significant differences (let's say from -15% to 15%)... Especially Rob
Bruce's add-ins is quite handy, but it highlights all differences. Any
ideas or suggestions? That would help me tremendously and save time so
much! Thank you so much in advance!
Best regards,
Mark
Rob's add-in:
http://www.rb-ad.dircon.co.uk/rob/excelvba/utils/index.htm
Myrna Larson and Bill Manville add-ins:
http://www.cpearson.com/excel/download.htm
I have been reading this group for a while, however I am quite a
rookie in using of excel. I would appreciate if someone could help
with this issue.
I quite often have to compare two sheets (from different
workbooks-files, but with the same sheet name). Calculations are thus
updated time by time and I need to check where were the main
differences. Cells contain both values and formulas. I have found
through this newsgroup nice add-ins of Myrna Larson and Bill Manville,
and Rob Bruce. However I would need the macros to highlight only
significant differences (let's say from -15% to 15%)... Especially Rob
Bruce's add-ins is quite handy, but it highlights all differences. Any
ideas or suggestions? That would help me tremendously and save time so
much! Thank you so much in advance!
Best regards,
Mark
Rob's add-in:
http://www.rb-ad.dircon.co.uk/rob/excelvba/utils/index.htm
Myrna Larson and Bill Manville add-ins:
http://www.cpearson.com/excel/download.htm