Results of calc as part of formula

[Tin Man]

I'm not sure how to explain this.

Numerous sheets (2 per month) all in a workbook.

Each is named JanNum, JanTot, FebNum, FebTot, etc.

Each Sheet does have a cell that defines the month, January for instance.

Throughout the sheets, there are references to the corresponding monthly
sheet.

What I am trying to do is LTrim the first three letters of the month label
and then use it in the formula. So the formula would take the "Jan" from the
label and insert it into the formula as the "Jan" part of a referenc to
"JanNum!"

Does that make sense and can I do it?

Tin

 

[Tin Man]

Ooops. I didn't mean Ltrim.
I meant Left, but you probably knew that.
Too many things at one time.

Tin

 

[Glenn Schwandt]

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

 

[Andy B]

Tin Man

Try:
=MID(CELL("FILENAME"),FIND("]",CELL("FILENAME"))+1,3)

Andy

 

[Tin Man]

Wow, 2 identical answers at the same time. Let me digest these a minute and
see if they work.

Thanks,

 

[Tin Man]

?
I need the first 3 of the worksheet, not the filename.

Is there a worksheet equivilent to "filename" in cell?

Tin Man

Try:
=MID(CELL("FILENAME"),FIND("]",CELL("FILENAME"))+1,3)

Andy

Ooops. I didn't mean Ltrim.
I meant Left, but you probably knew that.
Too many things at one time.

Tin
from
the

 

[Tin Man]

Ok, I'm following how that extracts the characters. I'm not seeing a way to
insert those characters into other formulas.
So, if my FebTotals repeatedly references FebNums, I want the formulas to
automatically adjust to different months, as long as they worksheet naming
syntax is followed.

Maybe I missed it. Sorry

 

[Tin Man]

Found an alternative - Thanks!