Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab Formula from diff sheets
I've been browsing through previous posts to find a way to show the tab name
of those several sheets to be displayed in a separate sheet. Tabs named Test1, Test2 etc names to be displayed in say "Final" wksht in cell a1 for Test1, cell a5 for Test2 etc. Tried this but it kept displaying "Final" wksht tab name and variants of code. =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) Any help be great. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab Formula from diff sheets
Use
=RIGHT(CELL("filename",'other sheet name'!A1),LEN(CELL("filename"'other sheet name'!A1))-SEARCH("]",CELL("filename"'other sheet name'!A1))) or a but simpler =MID(CELL("filename",'other sheet name'!A1),SEARCH("]",CELL("filename",'other sheet name'!A1))+1,99) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lenard" wrote in message ... I've been browsing through previous posts to find a way to show the tab name of those several sheets to be displayed in a separate sheet. Tabs named Test1, Test2 etc names to be displayed in say "Final" wksht in cell a1 for Test1, cell a5 for Test2 etc. Tried this but it kept displaying "Final" wksht tab name and variants of code. =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) Any help be great. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data from diff sheets to one common sheet | Excel Worksheet Functions | |||
How does a macro total columns when sheets have diff row counts? | Excel Discussion (Misc queries) | |||
average data from diff sheets | Excel Worksheet Functions | |||
how to add many cells on diff. sheets and put in 1 cell in excel | Excel Worksheet Functions | |||
Dragging formula linked to diff sheets | Excel Discussion (Misc queries) |