B
Busy Beaver
In the second worksheet, I want my formula in cell I2 to reference cell I2
of the first worksheet. I want to copy all of the second worksheet, and paste
in the third worksheet, and in cell I2 of the third worksheet, I want the
pasted formula to use cell I2 of the second worksheet, not cell I2 of the
first worksheet. But when I try this, Excel enters in cell I2 of the third
worksheet the formula from cell I2 of the second worksheet ''as is'', not as
a relative reference: In cell I2 of worksheet Q2, I have the following
formula:
=H2+'Q1'!I2
and this is what I want. In cell I2 of worksheet Q3, a paste y;elds
=H2+'Q1'!I2
but this is not what I want. I want the paste to give me the following, so
that I do not have to edit the pasted formula:
=H2+'Q2'!I2
of the first worksheet. I want to copy all of the second worksheet, and paste
in the third worksheet, and in cell I2 of the third worksheet, I want the
pasted formula to use cell I2 of the second worksheet, not cell I2 of the
first worksheet. But when I try this, Excel enters in cell I2 of the third
worksheet the formula from cell I2 of the second worksheet ''as is'', not as
a relative reference: In cell I2 of worksheet Q2, I have the following
formula:
=H2+'Q1'!I2
and this is what I want. In cell I2 of worksheet Q3, a paste y;elds
=H2+'Q1'!I2
but this is not what I want. I want the paste to give me the following, so
that I do not have to edit the pasted formula:
=H2+'Q2'!I2