Insert the "Tab Name" into cell contents

[Guest]

I keep a workbook of employee training; each "tab" of the workbook has the
name of the employee. Is there any way to insert the contents of the tab
label (the employee's name) into the contents of a cell within the worksheet?

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

You can get it using cell like so
=CELL("filename")

trim as needed

 

[Guest]

Well heck, guess I could do that trim for you. This works for me
=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))

 

[Gord Dibben]

John

Bob Phillips' explains this quite well and provides varying formulas.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben MS Excel MVP

 

[Dave Peterson]

I think:

=cell("filename",a1)
will be better.

If a range reference isn't included, then the formula will evaluate to whatever
workbook/worksheet is active at the time of the last calculation.

Well heck, guess I could do that trim for you. This works for me
=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.

You can get it using cell like so
=CELL("filename")

trim as needed