Originally Posted by rahulk912

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.