how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+

[Guest]

how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+1?

When I copy/paste the cell, the sheet reference doesn't change, I get
"sheet1!+1, when I copy/paste link I get a reference to the right sheet but
loose the "+1", e.g. I get "sheet2!. I need help!!!

 

[Guest]

YOu'll need to change the Sheet1 to Sheet2 when you copy it to sheet3.
Alternatively, if you have a lot of formulas to change, you could do a global
find and replace on that worksheet.

 

[Guest]

Thx Barb but that's too much work, I'm a lotus 123 user and when you copy
formulas to different sheets the sheet addresses move relatively just like
the cell addresses, there's got to be another way, don't you think?

 

[Guest]

I'm not aware of anything in Excel.

Thx Barb but that's too much work, I'm a lotus 123 user and when you copy
formulas to different sheets the sheet addresses move relatively just like
the cell addresses, there's got to be another way, don't you think?

 

[Guest]

when I tried the find '1 and replace it replaced every 1 (not every '1) in
the cell which messed things up even more. how can I specify better what to
replace?

 

[Dave Peterson]

How about
Sheet1!
with
sheet2!

when I tried the find '1 and replace it replaced every 1 (not every '1) in
the cell which messed things up even more. how can I specify better what to
replace?