| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Cell Referencing
Say I have week ones figures in cells in row 1 columns A1 to A5 and week two
figures in columns A6 to A10. I have a summary page that links to cells A1 to A5 to show them there. Would it be possible then in week two for the summary page to automatically update the reference cells to show cells A6 to A10 instead of A1 to A5? Basically is there any time based function or macro that could do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell referencing SC | Excel Discussion (Misc queries) | |||
| cell referencing | Excel Worksheet Functions | |||
| referencing a name from a cell value | Excel Discussion (Misc queries) | |||
| referencing the cell above | Excel Discussion (Misc queries) | |||
| Referencing a cell for a row | Excel Worksheet Functions | |||
Threaded Mode
