checking and comparing formulae
 

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

checking and comparing formulae
 

Have a look at these sites
http://www.mvps.org/dmcritchie/excel/duplicates.htm

http://www.cpearson.com/excel/duplicat.htm#Replacing

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

checking and comparing formulae
 

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.

"princecharlie" wrote:

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

checking and comparing formulae
 

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

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

checking and comparing formulae
 

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


"Neil M" wrote:

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.

"princecharlie" wrote:

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

checking and comparing formulae
 

Thanks Bernard I will check them out.

"Bernard Liengme" wrote:

Have a look at these sites
http://www.mvps.org/dmcritchie/excel/duplicates.htm

http://www.cpearson.com/excel/duplicat.htm#Replacing

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

checking and comparing formulae
 

Great many thanks Iwill try this......

"Paul B" wrote:

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

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