| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Refer to sheet name specified in other cell
Referring to cells in other sheets requires sythax: 'sheetname'!cellname. I have the situation in which sheet name is specified in another cell. How can I refer to cell in that sheet? E.g. A1 = "sheet1" A2 = "'A1'!B3" (I would like to refer to cell B3 in sheet1) Is that possible to do? Marko |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I cause a cell to return the sheet name i.e. sheet 1? | Excel Worksheet Functions | |||
| Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
| Need formula for sheet & cell reference | Excel Worksheet Functions | |||
| Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Threaded Mode
