Excel Tabs

C

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

dlw

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

MyVeryOwnSelf

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!
Click to expand...

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.)
 
A

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
 
Top