excelmacros321
New Member
- Joined
- Nov 11, 2017
- Messages
- 1
Hi All,
I have several worksheets in a single excel file. In one worksheet I have calculated my Monthly Forecast Result, using formulas which are linked with other worksheets in the same file. I have made another worksheet where I want to present Monthly Actuals +Forecasts.
The requirement is when I enter the actual result in any cell it should automatically populate the forecast for the following months in the following columns. For example; in Actuals+Forecast worksheet, I enter the value of $ 1,000 in the month of June, it should automatically populate values from Forecast worksheet for the next months i.e. July, August and so on. I wrote a macro for this but it is picking up the value from the wrong cell.
Is there any way to correct the macros or is there any simpler way to tackle this without macro, using any other formulas?
Thank you.
I have several worksheets in a single excel file. In one worksheet I have calculated my Monthly Forecast Result, using formulas which are linked with other worksheets in the same file. I have made another worksheet where I want to present Monthly Actuals +Forecasts.
The requirement is when I enter the actual result in any cell it should automatically populate the forecast for the following months in the following columns. For example; in Actuals+Forecast worksheet, I enter the value of $ 1,000 in the month of June, it should automatically populate values from Forecast worksheet for the next months i.e. July, August and so on. I wrote a macro for this but it is picking up the value from the wrong cell.
Is there any way to correct the macros or is there any simpler way to tackle this without macro, using any other formulas?
Thank you.