Linking Sheet Tab Name to Cell in Current Sheet 
Author Message
 Linking Sheet Tab Name to Cell in Current Sheet

Hello All:

Here is the scenerio:

I want to somehow link the sheet tab name (i.e. Employee List) to any cell
in the current sheet and when I change the sheet name, it would change in
the cell also.  I have went through the help menu and haven't had any luck.

Any suggestions would be much appreciated!

Thank you very much,

Jennifer



Wed, 16 Jun 2004 10:14:44 GMT  
 Linking Sheet Tab Name to Cell in Current Sheet
Hi Jennifer,

    Enter the following formula anywhere on the worksheet besides cell A1.
If you need to enter it into cell A1, change the reference to some other
cell. Which particular cell it references doesn't matter.

=MID(CELL("FileName",A1),FIND("]",CELL("FileName",A1))+1,999)

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


Quote:

> Hello All:

> Here is the scenerio:

> I want to somehow link the sheet tab name (i.e. Employee List) to any cell
> in the current sheet and when I change the sheet name, it would change in
> the cell also.  I have went through the help menu and haven't had any
luck.

> Any suggestions would be much appreciated!

> Thank you very much,

> Jennifer




Wed, 16 Jun 2004 10:22:47 GMT  
 Linking Sheet Tab Name to Cell in Current Sheet
Actually, it works in A1, too - I suspect there's no circular reference
because the function uses the address rather than the value.


Quote:

> Hi Jennifer,

>     Enter the following formula anywhere on the worksheet besides cell A1.
> If you need to enter it into cell A1, change the reference to some other
> cell. Which particular cell it references doesn't matter.

> =MID(CELL("FileName",A1),FIND("]",CELL("FileName",A1))+1,999)

> --
> Rob Bovey, MCSE, MCSD, Excel MVP
> Application Professionals
> http://www.appspro.com/

> * Please post all replies to this newsgroup *
> * I delete all unsolicited e-mail responses *



> > Hello All:

> > Here is the scenerio:

> > I want to somehow link the sheet tab name (i.e. Employee List) to any cell
> > in the current sheet and when I change the sheet name, it would change in
> > the cell also.  I have went through the help menu and haven't had any
> luck.

> > Any suggestions would be much appreciated!

> > Thank you very much,

> > Jennifer


--
Email address ROT13 encoded. Decode for real address.


Wed, 16 Jun 2004 12:03:38 GMT  
 Linking Sheet Tab Name to Cell in Current Sheet

Quote:
> Actually, it works in A1, too - I suspect there's no circular reference
> because the function uses the address rather than the value.

    Yep, it sure enough does. Good point.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *




Wed, 16 Jun 2004 12:48:15 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. VBA to link cell on one sheet to cell on another sheet

2. Cell reference sheet name vs tab name

3. Access Sheet Name (Value on Sheet Tab)

4. Color sheet tabs & Fonts in Sheet tabs

5. Names that refer to cells within current sheet

6. Sheet Name of current cell argument

7. Concatenated Cell as Sheet Tab Name?

8. Dynamic Cell Contents = Sheet Tab Name

9. Name of a sheet from the tab in a cell

10. Naming sheet tab to cell


 
Powered by phpBB® Forum Software © phpBB Group