| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to reference name of sheet tab
I am trying to figure out a way in Excel to reference the name of the sheet
tab using a formula. For example, in a new Excel document, the name of the first sheet tab defaults as "Sheet 1". I am trying to write a formula in cell A1 that would reference and show "Sheet 1" so that if I renamed "Sheet 1" as "Accounting", cell A1 would now read "Accounting. Thank you in advance for help anyone can provide, David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet name / reference as a formula? | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
| reference to sheets without using sheet names | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
