Viking1221
New Member
- Joined
- May 25, 2017
- Messages
- 32
Hello,
I am building forecast model and want to be able to forecast with formula inexcel, hard code or a formula in a macro. The spreadsheet it set up sothe user can update it with a hard coded number or enter a formula. However, I would also like to be able to adda macro that will overwrite all formula if it is selected.
So in Column D I will have options, such as 3, 6, 9 or 12month average. If this is selected it will overwrite what is in the forecastcells with the option they select. Theforecast cells will have ‘forecast’ in row 6 to identify it.
Is this doable?
I am building forecast model and want to be able to forecast with formula inexcel, hard code or a formula in a macro. The spreadsheet it set up sothe user can update it with a hard coded number or enter a formula. However, I would also like to be able to adda macro that will overwrite all formula if it is selected.
So in Column D I will have options, such as 3, 6, 9 or 12month average. If this is selected it will overwrite what is in the forecastcells with the option they select. Theforecast cells will have ‘forecast’ in row 6 to identify it.
Is this doable?