G
Guest
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
sheet name) without having to manually type it in
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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
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
G
Guest
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!
(probably because I am not an advanced user). Some more details or
explanation will help. thanks again!
David Billigmeier said: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 said: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
G
Guest
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
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 said: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 said: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 said: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
G
Guest
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!
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 said: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 said: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 said: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
:
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
G
Guest
No need to explain how it worked, I figured it out. I still wanna know how
you knew that though! Thanks!
you knew that though! Thanks!
David Billigmeier said: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 said: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 said: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
:
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
G
Guest
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
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 said: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 said: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
G
Guest
sorru David,
This will do
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
I found it some where,
Thank you
This will do
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
I found it some where,
Thank you
Dilano said: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 said: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 said: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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.