| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically change worksheet tab name
I have 16 sheets that are numbered 1 thru 16 on the tab. I also have a
17th sheet I have renamed "Data" (ignore quotes). I would like to type a name, (i.e., wonder) into cell a1 of the Data sheet and have that automatically change the name of sheet number 1 to "wonder". Then I would type another name (i.e., Hanger) into on the data sheet into cell a2 and that would change sheet number 2 to Hanger. I would continue to do this until all sheets are now changed to a name rather than a numer. Can this be accomplished by a formula? Thank you, Wally |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the source worksheet for 100 charts automatically. | Charts and Charting in Excel | |||
| Automatically change sequential worksheet names in formulas | Excel Worksheet Functions | |||
| worksheet tabs automatically change? | Excel Worksheet Functions | |||
| How do i get the excel worksheet to automatically add or change c. | Excel Discussion (Misc queries) | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
Threaded Mode
