Results of calc as part of formula

  • Thread starter Thread starter Tin Man
  • Start date Start date
T

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
 
Ooops. I didn't mean Ltrim.
I meant Left, but you probably knew that.
Too many things at one time.

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

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

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


Andy B said:
Tin Man

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

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

Tin
from
the
Click to expand...
Click to expand...
 
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
 
Back
Top