Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Tab/worksheet names to a worksheet cell
Hi Everyone
Is there any formula I can put in a cell so that it shows the tab/worksheet name? IE If my Tab name is "Supplier 1" I would like to have a cell in my worksheet which says Supplier 1. (Yes I'm lazy and hopefully there is a way to achieve this! Can't see the point in typing it twice, risking typos etc...) thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Tab/worksheet names to a worksheet cell
Try
=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"))) in any cell... "LinLin" wrote: Hi Everyone Is there any formula I can put in a cell so that it shows the tab/worksheet name? IE If my Tab name is "Supplier 1" I would like to have a cell in my worksheet which says Supplier 1. (Yes I'm lazy and hopefully there is a way to achieve this! Can't see the point in typing it twice, risking typos etc...) thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Tab/worksheet names to a worksheet cell
Formula works only after the file is saved at least once.
"LinLin" wrote: Hi Everyone Is there any formula I can put in a cell so that it shows the tab/worksheet name? IE If my Tab name is "Supplier 1" I would like to have a cell in my worksheet which says Supplier 1. (Yes I'm lazy and hopefully there is a way to achieve this! Can't see the point in typing it twice, risking typos etc...) thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Tab/worksheet names to a worksheet cell
You must include a cell reference......any one will do.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34) For explanation see Bob Phillips' site. http://www.xldynamic.com/source/xld.xlFAQ0002.html Gord Dibben MS Excel MVP On Sun, 8 Mar 2009 21:14:01 -0700, Sheeloo <Click above to get my email id wrote: Try =RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"))) in any cell... "LinLin" wrote: Hi Everyone Is there any formula I can put in a cell so that it shows the tab/worksheet name? IE If my Tab name is "Supplier 1" I would like to have a cell in my worksheet which says Supplier 1. (Yes I'm lazy and hopefully there is a way to achieve this! Can't see the point in typing it twice, risking typos etc...) thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Look up and match Vendor name in one cell of worksheet from list ofmultiple Vendor names in column of other worksheet | Excel Worksheet Functions | |||
Excel 2003 - Linking Formulas, Worksheet to Worksheet | Excel Discussion (Misc queries) | |||
Linking Formulas, Worksheet to Worksheet - Excel 2003 | Excel Discussion (Misc queries) | |||
Linking arrays and Worksheet names | Excel Worksheet Functions | |||
How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions |