Tab variable

[SF]

Hi,

I have 12 worksheets represent each month of the year. In every worksheet, I
have a label or header showing "Monthly Sale of XXXX". I try to combine
string with the [Tab] hoping to replace the XXXX with the name of the
Worksheet, but I am not able to acheive that.

Could the NG suggest something?

SF

 

[Max]

One way ..

Click Insert > Name > Define
Put under "Names in workbook:": WSN
Put in the "Refers to:" box:
=MID(CELL("Filename",INDIRECT("A1")),FIND("]",CELL("Filename",INDIRECT("A1")
))+1,32)
Click OK

The above defines WSN as a name we can use to refer to the sheetname in
formulas. It will auto-extract the sheetname implicitly (file must be saved
beforehand). Technique came from a post by Harlan.

Then you could use in any sheet, in any cell:
="Monthly Sale of "&WSN
to return the desired results