I have 53 week numbers along columns AE to CE
In column I is the total Quantity.
In column Y is the start week number – 7 in this case.
In column Z is the end week number – 15 in this case.
I want to be able divide the total quantity by the number of weeks 7 thru 15 = 9
and spread these into the relevant week no columns, with zeros in the other columns.
I bet this is really easy when you know how …