Worksheet Name in Spreadsheet

[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.

 

[Max]

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
----------------------------------------------------------------------------

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.

creating financial statements