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

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

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

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

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

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

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

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