Hi, Muhammad. Finally have the project ready to start. See the attached Excel doc. Here's what we need done:
You will see a tab called "Rollup Budget". We want this to dynamically reflect actual for previous months and forecast for the current and future months. On each subsequent tab you will see two sets of numbers. Top set are forecast/budget. Bottom set are actuals, based on invoices received (from the Submitted tab).
So for example, if I were to look at the Rollup Budget today (June 13), the columns in the Rollup budget for Jan - May would pull numbers from the Actuals set of numbers on all of the detail tabs, and the Jun - Dec columns would pull numbers from the forecast/budget numbers on the detail tabs. In July, Jun column would now show actuals with Jul - Dec pulling budget numbers.
Make sense? Guessing at budget so you can tell me real cost.