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.

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.

Create own module and insert this code:
Public Function name_file()
name_file = ActiveWorkbook.FullName
End Function

In cell write this: =name_file ()

result will full path with name of file.
name_file is your name, if you need different, rename it. ;-)

Peter

"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.

For sheet name change function to:
Public Function name_sheet()
name_sheet = ActiveSheet.Name
End Function

result will: name of sheet ;-)

"Peter Belko MOS MI" wrote:

Create own module and insert this code:
Public Function name_file()
name_file = ActiveWorkbook.FullName
End Function

In cell write this: =name_file ()

result will full path with name of file.
name_file is your name, if you need different, rename it. ;-)

Peter

"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.

Or,

Try the response to this FAQ at Debra Dalgleish's site:
http://www.contextures.com/xlfaqFun.html#SheetName



"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.