| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel: Sheet name from tab automically into a cell
How do I get a cell to reflect the value which lies in a sheet's tab (the
sheet name) without having to manually type it in |
|
#2
|
|||
|
|||
|
Hello -
CELL("filename") will output the full path of the sheet and tab you are in and: =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) Will take just the tab name. Hope that helps -- David Billigmeier "SWalton" wrote: How do I get a cell to reflect the value which lies in a sheet's tab (the sheet name) without having to manually type it in |
|
#3
|
|||
|
|||
|
David, thanks so much for helping but I don't understand your answer
(probably because I am not an advanced user). Some more details or explanation will help. thanks again! "David Billigmeier" wrote: Hello - CELL("filename") will output the full path of the sheet and tab you are in and: =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) Will take just the tab name. Hope that helps -- David Billigmeier "SWalton" wrote: How do I get a cell to reflect the value which lies in a sheet's tab (the sheet name) without having to manually type it in |
|
#4
|
|||
|
|||
|
Just copy and paste the following code (verbatim) into any cell on your
worksheet: =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) It will copy a text string corresponding to the tab name of the tab you are working in. Note, however, that the spreadsheet you are working in has to be saved or else it will output #VALUE! Better? -- David Billigmeier "SWalton" wrote: David, thanks so much for helping but I don't understand your answer (probably because I am not an advanced user). Some more details or explanation will help. thanks again! "David Billigmeier" wrote: Hello - CELL("filename") will output the full path of the sheet and tab you are in and: =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) Will take just the tab name. Hope that helps -- David Billigmeier "SWalton" wrote: How do I get a cell to reflect the value which lies in a sheet's tab (the sheet name) without having to manually type it in |
|
#5
|
|||
|
|||
|
Dude, you are my hero! That is just the absolute coolest thing! The
problem, as your surmised, is that the document was not saved. I have a deep-rooted desire to understand how this works so that in the future, my increased understanding will allow me to understand my own questions. I am studying the help descriptions which become available while clicking on the different parts of the formula in the formula bar and it provides a great deal of info but I don't understand how it knows to refer to the sheet tab as it's source? If you have time and are so inclined, could you explain? And, how do you know all of this anyway? are you a programmer? thanks again for your help! "David Billigmeier" wrote: Just copy and paste the following code (verbatim) into any cell on your worksheet: =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) It will copy a text string corresponding to the tab name of the tab you are working in. Note, however, that the spreadsheet you are working in has to be saved or else it will output #VALUE! Better? -- David Billigmeier "SWalton" wrote: David, thanks so much for helping but I don't understand your answer (probably because I am not an advanced user). Some more details or explanation will help. thanks again! "David Billigmeier" wrote: Hello - CELL("filename") will output the full path of the sheet and tab you are in and: =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) Will take just the tab name. Hope that helps -- David Billigmeier "SWalton" wrote: How do I get a cell to reflect the value which lies in a sheet's tab (the sheet name) without having to manually type it in |
|
#6
|
|||
|
|||
|
No need to explain how it worked, I figured it out. I still wanna know how
you knew that though! Thanks! "David Billigmeier" wrote: Just copy and paste the following code (verbatim) into any cell on your worksheet: =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) It will copy a text string corresponding to the tab name of the tab you are working in. Note, however, that the spreadsheet you are working in has to be saved or else it will output #VALUE! Better? -- David Billigmeier "SWalton" wrote: David, thanks so much for helping but I don't understand your answer (probably because I am not an advanced user). Some more details or explanation will help. thanks again! "David Billigmeier" wrote: Hello - CELL("filename") will output the full path of the sheet and tab you are in and: =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) Will take just the tab name. Hope that helps -- David Billigmeier "SWalton" wrote: How do I get a cell to reflect the value which lies in a sheet's tab (the sheet name) without having to manually type it in |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: Sheet name from tab automically into a cell
Dear David
I was looking for the smae solution and I came cross your reply to the gent. I have used this and it works, but If I have the same cell position in differnts Active Sheet in one file, all will refer to one Active sheet only, Let say I past it is a cell in TAB "101" and TAB "102" and so one, when I check all cells refer to #101 instead of #102, #103 as Active Sheet order, Is it what it supose to do. Thank you "David Billigmeier" wrote: Hello - CELL("filename") will output the full path of the sheet and tab you are in and: =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) Will take just the tab name. Hope that helps -- David Billigmeier "SWalton" wrote: How do I get a cell to reflect the value which lies in a sheet's tab (the sheet name) without having to manually type it in |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel: Sheet name from tab automically into a cell
sorru David,
This will do =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255) I found it some where, Thank you "Dilano" wrote: Dear David I was looking for the smae solution and I came cross your reply to the gent. I have used this and it works, but If I have the same cell position in differnts Active Sheet in one file, all will refer to one Active sheet only, Let say I past it is a cell in TAB "101" and TAB "102" and so one, when I check all cells refer to #101 instead of #102, #103 as Active Sheet order, Is it what it supose to do. Thank you "David Billigmeier" wrote: Hello - CELL("filename") will output the full path of the sheet and tab you are in and: =RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))) Will take just the tab name. Hope that helps -- David Billigmeier "SWalton" wrote: How do I get a cell to reflect the value which lies in a sheet's tab (the sheet name) without having to manually type it in |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel 2002 "Protect Sheet", but Allow "Insert Comments"? | Excel Worksheet Functions | |||
| Excel sheet not loading | Excel Discussion (Misc queries) | |||
| EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
| How do you set up a data excel sheet that links to a presentation. | Excel Worksheet Functions | |||
Linear Mode
