Worksheet name in cell formula

  • Thread starter Thread starter Phillip Topping
  • Start date Start date
P

Phillip Topping

I asked this question a while ago and got a prompt answer which I thought
was what I wanted but alas its not...

I want to be able to change my worksheet names.....ie: from Sheet 1, Sheet
2, etc etc.....to something more meaningful.....eg Sales, Expenses....etc
etc.... and have these changes reflect on the worksheet.

For example, I might want Sheet 1 Cell A1 to say.....This is the Sales
worksheet (assuming I have renamed it to Sales).

The answer I was given some time back worked.....but it changed the formula
on every worksheet to reflect the name of the last changed sheet.

By this I mean....if I changed Sheet 1 to Sales.... my formula on every
worksheet changed the cell refernce to "Sales", even though it was on
another sheet

Below is the formula I was given a few weeks ago by Ron Rosenfeld.

="This is "&MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)&"'s
worksheet"



TIA Phillip
 
Phillip,

Use

="This is
"&MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&"
worksheet"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top