Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to use R1C1 referencing to other worksheets in a file?
I have files that use a different worksheet for each month, and some of the cells on a sheet pull info from the previous month's worksheet. When I copy the Apr sheet, for example, and make it May, it would be nice for those cells to simply reference the previous sheet in the file, rather than having to do a search and replace for all references to Apr!. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
R1C1 reference | Excel Discussion (Misc queries) | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
R1C1 reference | Excel Discussion (Misc queries) | |||
Getting the value from a cell, and then using it as a name or R1C1 reference | Excel Programming |