cwrm4
12/18/2006 7:05:00 PM
On the source data worksheet, the rows are products, and the columns
are weeks (id'd by both week start (Monday) and the ISO week number).
Thus each cell in the body of the worksheet represents the demand for a
particular product for a particular week.
On the budget reporting worksheet, the rows are products, and the
columns are months.
So, I need a macro that will update the monthly data from the weekly,
splitting the weeks as needed (with demand for a week assumed to be
even across each day of that week).
For example, for the week of 30 Jan 2007, we have 100 units of demand.
On the monthly spreadsheet, 40 units of this demand needs to be added
to the January total (for 30-31 jan), and 60 units of demand needs to
be added to the February total (for 01-03 Feb).
Thanks,
Will
JLGWhiz wrote:
> We would need some idea of your spreadsheet layout, whether data runs by
> columns or by rows, etc. and what you are summing up i.e. hours or dollars or
> people or workload.
>
>