Does anyone know if you can automatically link the name of the individual sheet tab name to a cell in the same sheet?

In other words, if the sheet tab name is "Trains 09" I'd like to be able to have this title show up in a cell in the spreadsheet.

While you may not be able to link that info, you can format any cell or group of cells to display that info.

Quote:

---

Originally Posted by yellowjacket83

Does anyone know if you can automatically link the name of the individual sheet tab name to a cell in the same sheet?

In other words, if the sheet tab name is "Trains 09" I'd like to be able to have this title show up in a cell in the spreadsheet.

---

Yes it is possible, and it's very useful, especially if you're creating INDIRECT() formulas that utilize sheetnames in formulas. Very handy indeed.

The formula to show the sheet tab name in a cell is:

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

... but that won't work until AFTER you've saved the sheet at least once.

Quote:

---

Originally Posted by bones252100

While you may not be able to link that info, you can format any cell or group of cells to display that info.

---

This qualifies as "linking", so I would be interested to know what you were talking about in your hinted at alternate approach.