R1C1 reference to worksheets?
 

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!.

R1C1 reference to worksheets?
 

From the archives:

http://groups-beta.google.com/group/...misc/browse_fr
m/thread/5b923458a5d0dd4f/8955579b1d07023a

In article .com,
"Steve" wrote:

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!.

R1C1 reference to worksheets?
 

No direct support for it. You can be innovative and use Indirect in
conjunction with formulas to build a dynamic reference to the prior sheet.

--
Regards,
Tom Ogilvy


"Steve" wrote in message
oups.com...
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!.