Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell needs to show tab text
I have a multi-tabbed workbook. I would like to link a cell to the text
entered on the worksheet tab... I've seen it done before - but don't know how they were able to do that... Can someone fill me in? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell needs to show tab text
Hi,
Try this =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) The workbook must be saved for it to work. Mike "klee" wrote: I have a multi-tabbed workbook. I would like to link a cell to the text entered on the worksheet tab... I've seen it done before - but don't know how they were able to do that... Can someone fill me in? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell needs to show tab text
Mike,
Thanks. I tried that - however - - - it only kinda worked... Here's whats happening... I have 8 tabs in this workbook. I entered this formula separately on to each worksheet - but regardless of which worksheet I placed it on the same result appears on each... for example, text from tab one appears on all other worksheets. "Mike H" wrote: Hi, Try this =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) The workbook must be saved for it to work. Mike "klee" wrote: I have a multi-tabbed workbook. I would like to link a cell to the text entered on the worksheet tab... I've seen it done before - but don't know how they were able to do that... Can someone fill me in? Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell needs to show tab text
Hi,
I'm at a complete loss to explain that prehaps someone else can. Mike "klee" wrote: Mike, Thanks. I tried that - however - - - it only kinda worked... Here's whats happening... I have 8 tabs in this workbook. I entered this formula separately on to each worksheet - but regardless of which worksheet I placed it on the same result appears on each... for example, text from tab one appears on all other worksheets. "Mike H" wrote: Hi, Try this =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) The workbook must be saved for it to work. Mike "klee" wrote: I have a multi-tabbed workbook. I would like to link a cell to the text entered on the worksheet tab... I've seen it done before - but don't know how they were able to do that... Can someone fill me in? Thanks! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell needs to show tab text
On Jun 19, 11:42*pm, Mike H wrote:
Hi, I'm at a complete loss to explain that prehaps someone else can. Mike "klee" wrote: Mike, Thanks. *I tried that - however - - - it only kinda worked... Here's whats happening... I have 8 tabs in this workbook. *I entered this formula separately on to each worksheet - but regardless of which worksheet I placed it on the same result appears on each... for example, text from tab one appears on all other worksheets. "Mike H" wrote: Hi, Try this =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) The workbook must be saved for it to work. Mike "klee" wrote: I have a multi-tabbed workbook. *I would like to link a cell to the text entered on the worksheet tab... I've seen it done before - but don't know how they were able to do that... *Can someone fill me in? Thanks!- Hide quoted text - - Show quoted text - Make this function ::: Function sheet_name(sheet_index As Integer) As String sheet_name = Worksheets(sheet_index).Name End Function and then call it from the cell as sheet_name(1) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell needs to show tab text
Make sure you include a reference to the worksheet you want:
=MID(CELL("filename",a1),FIND("]",CELL("filename",a1))+1,255) Otherwise, excel will use the activeworkbook/activeworksheet when it evaluates that formula. You can use any cell on the sheet. I like to use the cell that contains the formula. klee wrote: Mike, Thanks. I tried that - however - - - it only kinda worked... Here's whats happening... I have 8 tabs in this workbook. I entered this formula separately on to each worksheet - but regardless of which worksheet I placed it on the same result appears on each... for example, text from tab one appears on all other worksheets. "Mike H" wrote: Hi, Try this =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) The workbook must be saved for it to work. Mike "klee" wrote: I have a multi-tabbed workbook. I would like to link a cell to the text entered on the worksheet tab... I've seen it done before - but don't know how they were able to do that... Can someone fill me in? Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I have a cell show text when it is blank? | Excel Discussion (Misc queries) | |||
Show cell reference as text | Excel Discussion (Misc queries) | |||
grab cell text from multi-tab workbook, show text in another workb | Excel Worksheet Functions | |||
How do I show all text in a cell? | Excel Discussion (Misc queries) | |||
some text sometimes to not show up in a cell? | Excel Discussion (Misc queries) |