linking a worksheet by a cell reference
 

I have a spreadsheet that will have tabs for each month. There are fomulas
in the worksheet that reference the previous months tab (that would be labled
for example March.) Is there any way that I could have a cell in the current
worksheet that you could input the previous months name and the formulas
automatically change to reference the proper worksheet with the same name?

I would ideally like to copy the worksheet change a cell for the previous
month and not have to re reference the formulas to pick up the proper tab.

linking a worksheet by a cell reference
 

Suppose you have ="March!A1" in D10 of the summary sheet
In some cell (say D9) enter the text March
In D10 use =INDIRECT(D9&"!A1")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"SC" wrote in message
...
I have a spreadsheet that will have tabs for each month. There are fomulas
in the worksheet that reference the previous months tab (that would be
labled
for example March.) Is there any way that I could have a cell in the
current
worksheet that you could input the previous months name and the formulas
automatically change to reference the proper worksheet with the same name?

I would ideally like to copy the worksheet change a cell for the previous
month and not have to re reference the formulas to pick up the proper tab.

linking a worksheet by a cell reference
 

On Apr 9, 8:40*am, SC wrote:
I have a spreadsheet that will have tabs for each month. *There are fomulas
in the worksheet that reference the previous months tab (that would be labled
for example March.) *Is there any way that I could have a cell in the current
worksheet that you could input the previous months name and the formulas
automatically change to reference the proper worksheet with the same name?

I would ideally like to copy the worksheet change a cell for the previous
month and not have to re reference the formulas to pick up the proper tab. *

SC, you might fiddle with this concept: On your current months tab,
create a dropdown list through data validation which contains a list
of all your tab names.

Now create formulas using the now visible selection as your referenced
range and do a series of lookups or whatever function you chose to
extract the desired data.

Its a start.
Pierre

linking a worksheet by a cell reference
 

Thanks!! That worked perfectly! It will definetly beat find & replacing
the worksheet reference!


"Bernard Liengme" wrote:

Suppose you have ="March!A1" in D10 of the summary sheet
In some cell (say D9) enter the text March
In D10 use =INDIRECT(D9&"!A1")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"SC" wrote in message
...
I have a spreadsheet that will have tabs for each month. There are fomulas
in the worksheet that reference the previous months tab (that would be
labled
for example March.) Is there any way that I could have a cell in the
current
worksheet that you could input the previous months name and the formulas
automatically change to reference the proper worksheet with the same name?

I would ideally like to copy the worksheet change a cell for the previous
month and not have to re reference the formulas to pick up the proper tab.