Worksheet Name in Spreadsheet

  • Thread starter Thread starter jtj703
  • Start date Start date
J

jtj703

I realize that I can put the worksheet name in a header or footer.
However, what I would like to do is have a function that grabs the tab
name and places it in a cell in my spreadsheet. That I way I can refer
to that value in a lookup table.


Please let me know if this is possible. Thank you very much.
 
Taken from MVP Debra D's:
http://www.contextures.com/xlfaqFun.html#SheetName

Put in say A1
: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

Above will give the sheet name.

Note: The file must be saved or the formula will not work.

--
hth
Max
-----------------------------------------
Please reply in thread

Use xdemechanik <at>yahoo<dot>com for email
----------------------------------------------------------------------------
jtj703 said:
I realize that I can put the worksheet name in a header or footer.
However, what I would like to do is have a function that grabs the tab
name and places it in a cell in my spreadsheet. That I way I can refer
to that value in a lookup table.


Please let me know if this is possible. Thank you very much.


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top