Hi,
First time posting so apologies if a little unclear.
I'm wondering if it is possible to lock a calculated value in?
So my issue -*
My forecasts are built from the past 3 months historical data (so week 1 (month 1), week 1 (month 2), week 1 (month 3) create week (month 4) forecast)
Now as I add more actual data in - which I can then compare actual vs forecast.
But when I add in new actuals - this update the next month's forecast, however, I want to be able to lock in a 3 month period at a time of forecasts.
-is this possible with a formula or VBA coding? (useless at VBA but will give it a go).
My only solution so far is copy and paste the values over the top once generated, but that's*not an option I'm allowed! haha
Thanks.
Bookmarks