Thread: Insert the "Tab Name" into cell contents
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Insert the "Tab Name" into cell contents
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?

Reply With QuoteReply With Quote