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?

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)



"John" wrote in message
...
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?

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

trim as needed
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"John" wrote:

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?

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.


"John Bundy" wrote:

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

trim as needed
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"John" wrote:

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?

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.

John Bundy wrote:

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.

"John Bundy" wrote:

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

trim as needed
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"John" wrote:

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?

--

Dave Peterson

John

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

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


Gord Dibben MS Excel MVP

On Wed, 7 Mar 2007 11:44:13 -0800, John wrote:

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?