| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a cell containing sheet name
I have a summary page in my workbook that has the individual sheet names listed in column A. Is there a way to reference the cells in column a within a formula so that the formula pulls the info from the appropriate page
This is what I want the end result to be.... A 1 Sheet1 ='Sheet1'!L3 2 Sheet2 ='Sheet2'!L3 3 Sheet3 ="Sheet3'!L3 but I would like to replace the " 'Sheet1'! " etc. with a reference to cells A1, A2 etc. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet referencing in a cell | Excel Discussion (Misc queries) | |||
| Referencing every 5th cell in another sheet | Excel Worksheet Functions | |||
| odd behavior when referencing a cell on another sheet | Excel Discussion (Misc queries) | |||
| referencing Excel sheet name in cell | Excel Worksheet Functions | |||
| referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions | |||
![Marcotte A[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
