Hi Excelling,

Look on Chip Pearson's formula page under Miscellaneous for an example of
how to do this:

http://www.cpearson.com/excel/excelF.htm

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

Excelling in MN wrote:
Version: Microsoft Office Excel 2003

How can I repeat a sheet's tab name in a cell?

I have a summary sheet which has data fed from multiple other
supporting sheets. The supporting sheets are updated by other users
and they modify the tab name so it reflects their specific subproject
effort.

Just as the summary sheet reflects the supporting sheet data, it
would be very helpful to state the tab name so it is clear what the
data is representing (i.e.- the subproject sheet name). I wish to
create a link so if the subproject (tab) name is changed, the summary
sheet is automatically updated.

I had hoped this would be similar to adding the file name and path in
a cell: =cell("filename") however, it is not.