| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refer to a sheet using a cell value
Hi, on "Sheet1" in cell A1 I have the string "Tony". I also have a
sheet named "Tony" I want to display the value of cell A1 in the sheet "Tony" on "Sheet1". Instead of using =Tony!A1 I would like to somehow use the the value in A1 ("Tony") to refer to the cell. I can then copy the formula to other cells easily to reference other sheets.. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Refer to a sheet using a cell value
Try this
=INDIRECT("'"&A1&"'!A1") Mike "bony_tony" wrote: Hi, on "Sheet1" in cell A1 I have the string "Tony". I also have a sheet named "Tony" I want to display the value of cell A1 in the sheet "Tony" on "Sheet1". Instead of using =Tony!A1 I would like to somehow use the the value in A1 ("Tony") to refer to the cell. I can then copy the formula to other cells easily to reference other sheets.. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Refer to a sheet using a cell value
Thanks for filling another hole in my Excel knowledge! ;-)
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying sheet references that refer to a cell in the preceding she | Excel Worksheet Functions | |||
| Countif - refer to another sheet | Excel Worksheet Functions | |||
| Refer to formula in another sheet | Excel Discussion (Misc queries) | |||
| Set up a formala to refer to a cell in a different sheet | Excel Worksheet Functions | |||
| Refer to sheet name specified in other cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
