| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Problem Summing Data in Cells on Previous Worksheets
Got it...never mind.
"David" wrote: I'm finishing a macro that lets me create a number of worksheets based on the days of the month. I have several cells on each worksheet that are Month to Date sums. For example, on Day 3, I need the month to date total of sales, so I need to look at today's actual sales (say in Cell C13) and add to Day 2's month to date total sales (In cell I13 on sheet(2), so forth and so on. I have five different data items I need to do this for on each sheet other than the first one. I'm trying to use the sheet(2) in the formula, but that is not working. I keep getting a pop up asked me where the sheet is. What I really need is a loop or do until the last sheet, starting with sheet(2) that will change the formula to look at the same cell (month to date total) on the prior sheet and add it to the current sheet's actuals daily sales (will always be the same cell) and the same for the other 4 datapoints. Can anyone help me with this? Thanks much! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing cells in Consecutive Worksheets | Excel Discussion (Misc queries) | |||
| Summing same cells in multiple worksheets | Excel Worksheet Functions | |||
| Summing same cells in multiple worksheets | Excel Worksheet Functions | |||
| Summing specific cells on two worksheets | Excel Discussion (Misc queries) | |||
| Referencing previous worksheets in formula | Excel Programming | |||
Threaded Mode
