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. |
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. |
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. |
All times are GMT +1. The time now is 07:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com