D
David
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!
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!