Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying a work sheet cell reference as relative not absolute?
Excel 2002, XP SP2
In preparing a sequence of annual reports on a standard template, I wish to prepare a table that refers to the previous year's results, in the previous sheet in a workbook. In copying the table to the next year, I want the sheet reference to be relative to the working one, i.e. the previous sheet(year). However when I copy the table including cell references to the succeeding sheet, the original sheet reference remains the same. One can declare cell references to be relative or absolute. How does one do the same for sheet references? The answer may be in the help files, but I cannot find it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Daily Totals on a summary sheet | Excel Worksheet Functions | |||
Getting contents of a cell when cell reference is in the sheet | Excel Discussion (Misc queries) | |||
Questions on copying from one sheet to the other and coping every other cell. | Excel Discussion (Misc queries) | |||
Cell reference problems with Summary sheet | Excel Worksheet Functions |