| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List tab names in cell range
I have a large # of worksheets where the tab names will change. I would like
to list them on a separate worksheet that will reflect any changes made to the worksheet tab. Is this possible or should I just re-type the list? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
List tab names in cell range
You can list them using
=MID(CELL("filename", Sheet1!A1), FIND("]", CELL("filename", Sheet1!A1)) + 1, 255) Which will return Sheet1. If the tab name changes, the formula will change to reflect the change. In article , JN wrote: I have a large # of worksheets where the tab names will change. I would like to list them on a separate worksheet that will reflect any changes made to the worksheet tab. Is this possible or should I just re-type the list? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
List tab names in cell range
You have no idea how grateful for your solution! Thanks so much!
"JE McGimpsey" wrote: You can list them using =MID(CELL("filename", Sheet1!A1), FIND("]", CELL("filename", Sheet1!A1)) + 1, 255) Which will return Sheet1. If the tab name changes, the formula will change to reflect the change. In article , JN wrote: I have a large # of worksheets where the tab names will change. I would like to list them on a separate worksheet that will reflect any changes made to the worksheet tab. Is this possible or should I just re-type the list? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help, change range names back to cell references? | New Users to Excel | |||
| create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
| Replace range names with cell references? | Excel Worksheet Functions | |||
Hybrid Mode
