| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling Tab Name of a Different Tab Than What I'm Working In
Hi, right now I'm using the below formula to pull the tab name of the tab I'm
working in. I need to also pull in the subsequent tab names into each subsequent column. For instance cell A1 will have the current tab name but B1 would be one tab to the right and C1 would be 2 tabs to the right, etc. Can anyone help me? =RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$ A$1))-FIND("]",CELL("filename",$A$1))) As always, thanks! Jon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate working days but change working week | Excel Discussion (Misc queries) | |||
| Pulling only first name | Excel Worksheet Functions | |||
| pulling out Numbers | Excel Discussion (Misc queries) | |||
| Pulling top 5 rank? | Excel Worksheet Functions | |||
| Pulling out every nth value | Excel Worksheet Functions | |||
![Jon Ratzel[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
