Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to populate a cell with the name of the worksheet it is in
I want to populate a cell with the name of a worksheet in the workbook so
that it will automatically update if the worksheet name changes. I have five worksheets and want to have cell a1 show the name of worksheet 1, cell a2 show the name of worksheet 2, etc. |
#2
|
|||
|
|||
See http://www.xldynamic.com/source/xld.xlFAQ0002.html
"MDF" wrote: I want to populate a cell with the name of a worksheet in the workbook so that it will automatically update if the worksheet name changes. I have five worksheets and want to have cell a1 show the name of worksheet 1, cell a2 show the name of worksheet 2, etc. |
#3
|
|||
|
|||
MDF, have a look here on how to do it
http://www.xldynamic.com/source/xld.xlFAQ0002.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "MDF" wrote in message ... I want to populate a cell with the name of a worksheet in the workbook so that it will automatically update if the worksheet name changes. I have five worksheets and want to have cell a1 show the name of worksheet 1, cell a2 show the name of worksheet 2, etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
How do I populate a cell with the NT Logon username? | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions | |||
Syntax for inferred cell references | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |