checking and comparing formulae

P

princecharlie

I have two different work books within which are hopefully two identical work
sheets. However can I automatically check to see if each cell formulae within
each sheet is in fact identical or do I have to use split screen to check
each cell manually by sight?
Thanks Jerry
 
N

Neil M

On sheet 1 cell A1 the formula should be

=Sheet2!A1

If you use this there should be no question of wether or not they are
identical. The only variation would be if cell A1 on sheet 1 was formatted
one way and cell A1 on sheet 2 was formatted another way.

I don't believe there is a way to check if they both are identical other
than manually.There are 'getformula' functions as well, but it still means
manually entering some type of text on the second sheet.

I think your best option would be to create the first sheet and then use
"copy sheet" by right clicking on the tabs. That would copy sheet 1 exactly
as it appears. You could then change any text if needed, but your formulas
would remain. I hope this helps.
 
P

Paul B

princecharlie, have a look here, http://www.cpearson.com/excel/download.htm
look for the compare addin
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
P

princecharlie

Many thanks for that but I don't think I have explained myself correctly.
What happened was that I created the first work sheet which was then altered
by someone else and sent back as a separate attachment. I now have two work
sheets which should do the same thing but one is slightly diofferent in its
formulae than the other one and I want to check where are the differences .
Unfortunately the person who altered the original sheet has gone away!!
Thanks anyway.
Cheers
 
Top