Distributing Sales Figure Over Time |VBA & Macros|Excel Forum|My Online Training Hub

Hello, 

I am trying to develop a sales tracking tool to allow me to see the current sales going through the business over a time period. I would like to have the document live, so that as new work orders are created, the distribution slides across the time table. By time table I mean the first job open and last to close, this may be a few weeks to a few months. 

Ideally, if I have for instance a $10,000 job, that has a kick off date to due date time period of 10 weeks, it is distributed into $1000/week. 

I have attached the chart that I currently use, if anyone could help with the formula it would be a great help. 

Thank you, 

Dennis