excel 2002 - copying formulas to another worksheet

[Guest]

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?

 

[Gordon]

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!

 

[Guest]

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