Hi, I am preparing a forecast model. I have populated lots of sales data by quarter on the basis that the launch is in quarter 1 and other products come on line 2,3,4 etc.
my profit and loss is by month which captures pre revenue costs etc.
I want to be able to be able to change the date of launch and have my sales data populated into the relevant months!
any ideas?
thanks
my profit and loss is by month which captures pre revenue costs etc.
I want to be able to be able to change the date of launch and have my sales data populated into the relevant months!
any ideas?
thanks