| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summary sheet from tab names
I have been racking my brain on how to make this work! I have created a
workbook with 70 tabs and a summary sheet linking to specific info on each worksheet. I would like to be able to change the tab name and have that change on the summary sheet as well. Is this possible? Examble tab name is currently generic "Person 1" Summary sheet is also (manually) entered as "Person 1" I want to be able to rename the tab to Jim Smith and have that update on the summary sheet as well. I have not worked with macros Thanks Joe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summary of Worksheet names | Excel Discussion (Misc queries) | |||
| how do you make a summary page showing the workbook name with the excel sheet names | New Users to Excel | |||
| Displaying information (contained in defined names) on a summary sheet, in different row numbers? | Excel Discussion (Misc queries) | |||
| totals sheet- need summary of column of names between sheets | Excel Discussion (Misc queries) | |||
| Creating a list of worksheet names on a Summary PAge | Excel Worksheet Functions | |||
Threaded Mode
