Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
refer to tab info in a cell
Excel 2000, Vista
How do you refer to the info on the tab (worksheet name) in a cell in the worksheet Thank you, Bill |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
refer to tab info in a cell
=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename")))
-- Gary''s Student - gsnu2007j |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
refer to tab info in a cell
Try this:
A1: =MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,255) Does that help? Post back if you have more questions. Regards, Ron Microsoft MVP - Excel "bpauley" wrote in message ... Excel 2000, Vista How do you refer to the info on the tab (worksheet name) in a cell in the worksheet Thank you, Bill |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
refer to tab info in a cell
Gentlemen,
Thank you so much for the quick and efficient assistance. Both formulas worked well, however, Ron's permitted for changes in the tab name to be displayed in the cell in the worksheet immediately. Don't know why but it did. So, that is the formula I am using. Again thank you both for the assistance. Bill "Ron Coderre" wrote in message ... Try this: A1: =MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,255) Does that help? Post back if you have more questions. Regards, Ron Microsoft MVP - Excel "bpauley" wrote in message ... Excel 2000, Vista How do you refer to the info on the tab (worksheet name) in a cell in the worksheet Thank you, Bill |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
refer to tab info in a cell
This formula will give you spurious results.
=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) See Bob Phillips' site for explanation. http://www.xldynamic.com/source/xld.xlFAQ0002.html Gord Dibben MS Excel MVP On Sun, 8 Jun 2008 08:56:05 -0400, "bpauley" wrote: Gentlemen, Thank you so much for the quick and efficient assistance. Both formulas worked well, however, Ron's permitted for changes in the tab name to be displayed in the cell in the worksheet immediately. Don't know why but it did. So, that is the formula I am using. Again thank you both for the assistance. Bill "Ron Coderre" wrote in message ... Try this: A1: =MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,255) Does that help? Post back if you have more questions. Regards, Ron Microsoft MVP - Excel "bpauley" wrote in message ... Excel 2000, Vista How do you refer to the info on the tab (worksheet name) in a cell in the worksheet Thank you, Bill |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
refer to tab info in a cell
Gord,
thanks for the info. Mr Phillips site is a nice resource, thanks for that also. Bill "Gord Dibben" <gorddibbATshawDOTca wrote in message ... This formula will give you spurious results. =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) See Bob Phillips' site for explanation. http://www.xldynamic.com/source/xld.xlFAQ0002.html Gord Dibben MS Excel MVP On Sun, 8 Jun 2008 08:56:05 -0400, "bpauley" wrote: Gentlemen, Thank you so much for the quick and efficient assistance. Both formulas worked well, however, Ron's permitted for changes in the tab name to be displayed in the cell in the worksheet immediately. Don't know why but it did. So, that is the formula I am using. Again thank you both for the assistance. Bill "Ron Coderre" wrote in message ... Try this: A1: =MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,255) Does that help? Post back if you have more questions. Regards, Ron Microsoft MVP - Excel "bpauley" wrote in message ... Excel 2000, Vista How do you refer to the info on the tab (worksheet name) in a cell in the worksheet Thank you, Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Refer to a url and retreive info for a spreadsheet | Excel Worksheet Functions | |||
How to refer to every 5 th cell? | Excel Discussion (Misc queries) | |||
how do i get excel to see info in one cell, look at info in anoth. | Excel Discussion (Misc queries) |