Hi all,
I'm trying to write a macro that does the following:
Takes the Value in #1, Divides it by number of weeks (#2) and Spreads it based on the Starting Date, rounded up to the nearest Sunday.
So in the example below, I need to insert the value $100 000/20 = $5000 into the 20 cells starting after 2021-03-06 (the nearest Sunday).
The complication is that I must skip any columns that say "SKIP" (Column AQ)
Can anyone assist? It would be much appreciated, and I would be more than happy to ubereats you some food.
I'm trying to write a macro that does the following:
Takes the Value in #1, Divides it by number of weeks (#2) and Spreads it based on the Starting Date, rounded up to the nearest Sunday.
So in the example below, I need to insert the value $100 000/20 = $5000 into the 20 cells starting after 2021-03-06 (the nearest Sunday).
The complication is that I must skip any columns that say "SKIP" (Column AQ)
Can anyone assist? It would be much appreciated, and I would be more than happy to ubereats you some food.