Problem with formula in grouped sheets

[Bo]

Excel 2003

I have 99 tabbed worksheets in one workbook. All 99 have the same template.
Each template collects a weeks worth of data and calculates a year to date
column. I have grouped sheets 2-99 and on the active sheet 2 entered the
following formula.

=+Sheet1!E13+Sheet2!D13

Sheet1 E13 being the previous week year to date. Sheet2 D13 being this weeks
total.

Problem: The formula in all sheets 3-99 always look at the data in Sheet1
and Sheet2 as if the formula read =+$Sheet1$E13+$Sheet2$D13. How do you make
it quit.

 

[Squeaky]

What are you wanting the formula to do in those sheets?

 

[jaf]

Hi Bo,
That's what is Excel will do when you group sheets. It gets the value from cell e13 and adds it to d13 on all sheets.

If that's not what you want, you have to enter the formula in each cell separately.

You can record a macro while doing the first one and then have it loop through the other sheets.

If you need help with the macro, post back with some sample data and the sheet names.
I'm sure someone can help.

John