Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas and worksheets
I have a several worksheets that are all named for a date. They total onto
one sheet. I have to add a new worksheet every two weeks and don't know how to add the worksheet into the total page without having to seperately add the formula in to every cell (=/- 525 cells). I also have to add and delete rows and the formulas don't then change with it's new corresponding row. I need serious help!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas and worksheets
Hi Babs,
No one can help you without a description of the problem, you have to know what cells are to be added together.. If your totals are in the same location on each sheet, then you can place the sheets to be totaled together and use a 3D reference look it up in HELP. if you have sheets 2006-04-01 through 2006-05-20 you dould use summary sheet cell D200 to contain sum of cell D200 from other sheets =SUM('2006-04-01':'2006-05-20'!D200) You could use empty sheets at the ends =SUM(begsheet:endsheet!D200) I would suggest you make the empty sheets look like dates (yyyy-mm-dd) so that you can sort them if necessary. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Babsfarley" wrote in message ... I have a several worksheets that are all named for a date. They total onto one sheet. I have to add a new worksheet every two weeks and don't know how to add the worksheet into the total page without having to seperately add the formula in to every cell (=/- 525 cells). I also have to add and delete rows and the formulas don't then change with it's new corresponding row. I need serious help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying formulas from multiple worksheets | Excel Worksheet Functions | |||
Formulas in Worksheets | Excel Discussion (Misc queries) | |||
apply cell names to formulas in multiple worksheets | Excel Worksheet Functions | |||
Copy worksheets with formulas between different workbooks | Excel Discussion (Misc queries) | |||
Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) |