Excel Tabs

[ckane]

I have a worksheet with several tabs. Each tab is a different persons name.
Is there a way to have the name on the tab automatically show up in a
specific cell on the worksheet. Thank you!

 

[dlw]

it's the last thing in =cell("filename") maybe you could use MID and RIGHT or
something to pick it out?

 

[Andy Pope]

Hi,

As has been suggested the CELL function will give you the information.

But if you want the sheet name of each individual sheet remember to
include a cell reference in the CELL function otherwise all sheets will
display the same information, which will at least be correct for 1 of
the sheets

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

Cheers
Andy