excel 2002 - copying formulas to another worksheet
 

I am trying to copy a worksheet (sheet2) to a new worksheet (sheet3) all
within the same file, but when I do the copy, not all of the formulas
changed. The formulas that did not change all reference a sheet number.

This is an example of one of my formulas under sheet2: =+Sheet1!B3+1.

When I copy this to the new worksheet (sheet3), I want it to be:
=+Sheet2!b3+1, but the formula will not change.

Any ideas on how I can have the sheet number change automaticly?

Greg wrote:
I am trying to copy a worksheet (sheet2) to a new worksheet (sheet3) all
within the same file, but when I do the copy, not all of the formulas
changed. The formulas that did not change all reference a sheet number.

This is an example of one of my formulas under sheet2: =+Sheet1!B3+1.

When I copy this to the new worksheet (sheet3), I want it to be:
=+Sheet2!b3+1, but the formula will not change.

Any ideas on how I can have the sheet number change automaticly?
easiest way is to do a Find and Replace in worksheet 3. Replace Sheet1
with Sheet2

--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!

Relative referencing does not work between sheets so you either have to use a
macro, UDF or do an edit replace

http://tinyurl.com/4ftky

Regards,

Peo Sjoblom

"Greg" wrote:

I am trying to copy a worksheet (sheet2) to a new worksheet (sheet3) all
within the same file, but when I do the copy, not all of the formulas
changed. The formulas that did not change all reference a sheet number.

This is an example of one of my formulas under sheet2: =+Sheet1!B3+1.

When I copy this to the new worksheet (sheet3), I want it to be:
=+Sheet2!b3+1, but the formula will not change.

Any ideas on how I can have the sheet number change automaticly?