I have to keep track of daily sales vs daily quotas for a number of stores. I also have to provide store managers with daily updates to their store's goals based on sales up to that date.
Quotas data is its own separate worksheet.
Daily sales data is its own separate worksheet.
I have a third worksheet that pulls the quotas and sales data for each store and makes it "presentable" so I can send each store manager a nice screen grab every morning.
Some days a store will go over the sales quota and some days the store will fail to reach the daily sales quota. This creates a variance that accumulates as each day goes by.
What I'm trying to do is to take that accumulated variance and distribute it to the upcoming days (1 unit) per day so that the actual sales + the new quota matches the original quota total.
I'm adding a sample sheet just in case.
Not quite sure if this would be easier as a plain formula, or if VBA would be the way to go. So that's why I'm posting to the General forum.
Thanks in advance.