Sus Controlling
New Member
- Joined
- Oct 15, 2014
- Messages
- 3
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total YTD | Total YE | |
Actual | Actual | Actual | Actual | Actual | Actual | Actual | FCST | FCST | FCST | FCST | FCST | YTD | All | |
pt1 | 10 | 10 | 10 | 10 | 15 | 15 | 15 | 20 | 20 | 20 | 30 | 30 | 85 | 205 |
pt2 | ||||||||||||||
pt3 |
<tbody>
</tbody>
Each month I want the formula for YTD to reflect the new month's actual data. They will load the label "Actual" in the column heading and replace the previously loaded forecast data. I want the formula to automatically be ready to sum accordingly for the Actual values. The spreadsheet is huge and has similar areas where this is needed and I need to avoid the user forgetting to adjust these formulas.