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!

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

"ckane" wrote:

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!

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!

One way:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)

The name is for the tab containing the cell that contains the formula.

This works once the file has been saved for the first time.

(I have Excel 2003. I got this formula from somebody's earlier post to this
newsgroup.)

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

ckane wrote:
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!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info