sheet names to cells

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

Hi all. Thanks in advance for your help.

I have 2 questions/issues:

1. Is there a way to have the name of a sheet show up in a
cell?

2. I am setting up a workbook to help simply scheduling
classes for a school. I would like to look through a
column of classes, find a teacher's name, then copy the
information from that period to another sheet. I'm not
sure if this makes any sense, but basically, I'm trying to
create a system in which a principal can input a master
schedule, and the information automatically links to other
sheets to create teacher schedules.

Hope someone can help. Thanks.
 
Aaron

1) Assuming that the spreadsheet has already been saved,
then the formula
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND
("]",CELL("filename",A1)))
will get the sheet name. Make sure that you don't put the
formula in A1. While it will seem to work, there are
situations where if the formula is in the same cell it
refers to, it may not update properly.

2) Need more detail on the structure of the source and
destination sheets to respond.


Tony
 
Thanks. That worked. I'm surprised there is no easy way to accomplish
this. Thanks so much for your help.


--
 
Hi!
I had the same question as your number 1 not long ago and
found the answer on another site. The following formula
will return the name of your worksheet:

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

Good luck!
Parisicaine
 
Back
Top