Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with formula in grouped sheets
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with formula in grouped sheets
What are you wanting the formula to do in those sheets?
"Bo" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with formula in grouped sheets
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 "Bo" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula problem in grouped worksheets | Excel Discussion (Misc queries) | |||
Paste into grouped sheets using VB | Excel Worksheet Functions | |||
create alert when in sheets are grouped | Excel Worksheet Functions | |||
Replace with Grouped Sheets | Excel Discussion (Misc queries) | |||
Grouped Sheets and Formating | Excel Discussion (Misc queries) |