| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Tab Content
Is there a formula I can use for a cell that will populate a cell with the
content of a sheet tab? Thank you, Karen |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for Tab Content
Karen,
Put this in a cell. The workbook must be saved for it to work =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) Mike "Karen" wrote: Is there a formula I can use for a cell that will populate a cell with the content of a sheet tab? Thank you, Karen |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for Tab Content
Thank you so much Mike! It worked great!
Have a wonderful weekend! Karen "Mike H" wrote: Karen, Put this in a cell. The workbook must be saved for it to work =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) Mike "Karen" wrote: Is there a formula I can use for a cell that will populate a cell with the content of a sheet tab? Thank you, Karen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Content linked to other cells formula Content | Excel Discussion (Misc queries) | |||
| Formula not updating to new content. | Excel Worksheet Functions | |||
| How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
| Cell content / formula bar different | Excel Discussion (Misc queries) | |||
| Formula reading formula instead of cell content | Excel Worksheet Functions | |||
Linear Mode
