| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Names is Defined by Cell value on Sheet 1 (named Summary
Is there a way to have a certain worksheet assume the text in a cell:
sheet 2 renaming itself to whatever is in cell a1 of Summary (formerly sheet1) sheet 3 renaming itself to whatever is in cell a5 of Summary (formerly sheet1) sheet 4 renaming itself to whatever is in cell a9 of Summary (formerly sheet1) and so on...worksheets count will vary depending on projects ALSO, automatically updating any reference to the renamed sheet throughout the workbook. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summary of Worksheet names | Excel Discussion (Misc queries) | |||
| Summary sheet from tab names | Excel Discussion (Misc queries) | |||
| Displaying information (contained in defined names) on a summary sheet, in different row numbers? | Excel Discussion (Misc queries) | |||
| Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
| Using non defined names from another sheet | Excel Worksheet Functions | |||
Threaded Mode
