| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link to previous tab
I have a cell in my worksheet which links to the previous worksheet. i.e I'm
in Nov 08 and the cell looks at a cell in Oct 08 sheet. Whenever I copy this sheet to create the next month, I have to update the link to the previous month's sheet. =Oct 08!A4 must be changed to Nov 08!A4. Can I create a formula which will do =[cell one to the left]!A4? Thanks Maria :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy two linked sheets, and update the link isn't to the previous | Excel Discussion (Misc queries) | |||
| VBA Link - Previous post unclear | Excel Discussion (Misc queries) | |||
| Previous Documents | Excel Discussion (Misc queries) | |||
| if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
| if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
Threaded Mode
