ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   forecasting sheet - macro required (https://www.excelbanter.com/excel-discussion-misc-queries/266115-forecasting-sheet-macro-required.html)

rahulk912
forecasting sheet - macro required
 
1 Attachment(s)
Hi,
I need some help with this sheet. I need to write a macro for changing the units and prices according to inputs in table M5:N8 with the intervals selected in table J5:J9. The units and prices from n24 onwards will be calculated according to the growth rate specified. Also if one enters"R" the macro will calculate regression accordingly. This will translate into forecast revenues according to the inputs.

David of XL Plus
Quote:
Originally Posted by rahulk912 (Post 959779)
Hi,
I need some help with this sheet. I need to write a macro for changing the units and prices according to inputs in table M5:N8 with the intervals selected in table J5:J9. The units and prices from n24 onwards will be calculated according to the growth rate specified. Also if one enters"R" the macro will calculate regression accordingly. This will translate into forecast revenues according to the inputs.
Hi,

I don't fully understand what you are trying to achieve.

A couple of examples based on your data will help.

Educo


All times are GMT +1. The time now is 09:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com