Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: Relative worksheet references?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel insits that I use absolute cell references | Excel Discussion (Misc queries) | |||
Relative referencing in Microsoft Excel between worksheets | Excel Discussion (Misc queries) | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Named references broken on copied worksheet | Excel Discussion (Misc queries) | |||
Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) |