sheet name

[mdcerino]

is there a way to have a cell reference a sheet/tab name? I want cell A
to say the name of the shee

 

[JE McGimpsey]

One way:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

The worksheet must be saved first.

 

[davezuspann]

I need the exact same thing. surely there is a way to
create a formula for this. No way I have to do this by
hand. Can anyone help us? How can you reference a
worksheet tab by using a cell value reference that can be
copied?

 

[JE McGimpsey]

Did you read the reply?

Or did you try searching the archives?

http://groups.google.com/advanced_group_search?q=group:*excel*

 

[Don]

Hi JE,

Thanks for that reply...although I'm not the orginal
poster, I like that and will store it for future use.
Also found out that once the WB is saved you can change
the name of the sheet and A1 or whatever changes with it,
without having to save the Book again. But then, you
probably already knew that......

Thanks again,

Don