same formula and cells for different worksheets

[deskmac]

I am struggling to find an answer to my dilemma.

I have a workbook with dates of the month, 1-31, then a summary sheet wherein I would like to calculate averages for certain parameters. I can set-up the formulas for sheet 1 but how do I "copy" this formula for sheet 2. WhenI drag/copy&paste I find that the formula still refers to sheet 1 and not sheet 2. I know how to inform excel that I want it to keep the same cells with the "$" sign but how do I inform it to give me the average for sheet 2 and not sheet 1?

Any help is highly appreciated.

Cheers,

James

 

[GS]

(e-mail address removed) formulated the question :

I am struggling to find an answer to my dilemma.

I have a workbook with dates of the month, 1-31, then a summary sheet wherein
I would like to calculate averages for certain parameters. I can set-up the
formulas for sheet 1 but how do I "copy" this formula for sheet 2. When I
drag/copy&paste I find that the formula still refers to sheet 1 and not sheet
2. I know how to inform excel that I want it to keep the same cells with the
"$" sign but how do I inform it to give me the average for sheet 2 and not
sheet 1?

Any help is highly appreciated.

Cheers,

James

If the formulas are in the same cells on all sheets then you can group
the sheets and just enter formulas on 1 of the group. Alternatively,
you can use a 'template' sheet and just make copies as needed.
Personally, I'd likely include all months (and summary) on a single
sheet and keep an entire year on 1 sheet. But then, it depends on the
nature of the task...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion