I use a rolling 12 months spreadsheet that has a sheet for each month of
activity, and is a home sheet of rother workbooks to connect to and pick up
relevant data. As I delete old sheets and add clone new ones I have to
manually change the title cell name of the sheet to the proper month. I would
like to be able to just change the name of the tab, (example: "Sep_05"), and
have that name propagate to the title cell on that page.

See

http://www.mcgimpsey.com/excel/formu..._function.html

In article ,
Archie N. <Archie wrote:

I use a rolling 12 months spreadsheet that has a sheet for each month of
activity, and is a home sheet of rother workbooks to connect to and pick up
relevant data. As I delete old sheets and add clone new ones I have to
manually change the title cell name of the sheet to the proper month. I would
like to be able to just change the name of the tab, (example: "Sep_05"), and
have that name propagate to the title cell on that page.

Excellant!! Your information is superb! Thank you very much JE!

"JE McGimpsey" wrote:

See

http://www.mcgimpsey.com/excel/formu..._function.html

In article ,
Archie N. <Archie wrote:

I use a rolling 12 months spreadsheet that has a sheet for each month of
activity, and is a home sheet of rother workbooks to connect to and pick up
relevant data. As I delete old sheets and add clone new ones I have to
manually change the title cell name of the sheet to the proper month. I would
like to be able to just change the name of the tab, (example: "Sep_05"), and
have that name propagate to the title cell on that page.