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?

"Barb Reinhardt" wrote:

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.

"Dany" wrote:

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!!!