M
Mark Dvorkin
Hi all:
I have a workbook that has up to 30 sheets, i.e. one sheet for each day
of the month.
For ex.: Nov1, Nov2 and so on.
I'm averaging values in cell AA32 by
=AVERAGE(Nov1:Nov2!AA32)
As the month progresses a new sheet is added, i.e. I copy the last
sheet, say Nov2 and get Nov2(1)
I rename it to Nov3 and now I have to go to cell AA32!Nov3 and edit Nov2
in the average formula
to Nov3
Is there a way to get the name of an active sheet without using VBA?
Tanks in advance,
/mark
I have a workbook that has up to 30 sheets, i.e. one sheet for each day
of the month.
For ex.: Nov1, Nov2 and so on.
I'm averaging values in cell AA32 by
=AVERAGE(Nov1:Nov2!AA32)
As the month progresses a new sheet is added, i.e. I copy the last
sheet, say Nov2 and get Nov2(1)
I rename it to Nov3 and now I have to go to cell AA32!Nov3 and edit Nov2
in the average formula
to Nov3
Is there a way to get the name of an active sheet without using VBA?
Tanks in advance,
/mark