| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing tab based on Variable
There is a workbook with a sheet for every month (Jan - Dec) Is there a way
to reference a sheet based on a variable that a user defines? For example: I have a summary sheet named 'Summary'; in cell 'Summary'!A1 I have a drop down that a user can choose a month from. In cell 'Summary'!A2 I would like to return whatever is in cell A1 in the sheet that has the same name as what is selected in the dropdown. (eg if the user selects Jan I would like to return 'Jan'!A1) Thanks in advance for all of your help, Chad |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Referencing tab based on Variable
=indirect("'"&A1&"'!A1")
"Chad" wrote: There is a workbook with a sheet for every month (Jan - Dec) Is there a way to reference a sheet based on a variable that a user defines? For example: I have a summary sheet named 'Summary'; in cell 'Summary'!A1 I have a drop down that a user can choose a month from. In cell 'Summary'!A2 I would like to return whatever is in cell A1 in the sheet that has the same name as what is selected in the dropdown. (eg if the user selects Jan I would like to return 'Jan'!A1) Thanks in advance for all of your help, Chad |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Referencing tab based on Variable
Just what I needed.
Thanks! "bj" wrote: =indirect("'"&A1&"'!A1") "Chad" wrote: There is a workbook with a sheet for every month (Jan - Dec) Is there a way to reference a sheet based on a variable that a user defines? For example: I have a summary sheet named 'Summary'; in cell 'Summary'!A1 I have a drop down that a user can choose a month from. In cell 'Summary'!A2 I would like to return whatever is in cell A1 in the sheet that has the same name as what is selected in the dropdown. (eg if the user selects Jan I would like to return 'Jan'!A1) Thanks in advance for all of your help, Chad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable in VLOOKUP and referencing a cell another file in excel | Excel Worksheet Functions | |||
| Variable Cell Referencing | Excel Worksheet Functions | |||
| Referencing a Value in variable length columns. | Excel Worksheet Functions | |||
| Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
| Referencing Variable Name Worksheets | New Users to Excel | |||
Linear Mode
