Using one 'input' cell to store 'time lag' amount to drive the location / date of dependent worksheet cells

0

Hi.

So, I am building a monthly income / expense forecasting model with a sales funnel and am looking to use one set of 'input cells' for the length of each stage - for example one called 'Months (or days) to convert a lead into a demo' - and 'months (or days) to convert a demo into a free trial', etc.

Based on the values that show here, I want to 'move revenue recognition' into the dates that are appropriate.  So, I will be putting in the leads in the month columns, but I want the various stages to automatically change to the appropriate columns based on the 'time lags' put in as inputs in the assumptions / inputs area.

How would I do this?  Any thoughts?  Any help would be huge!

Best,

Tom

Answer
Discuss

Discussion

Obviously, you have planned this very well. It will be hard for an outsider to catch up without some serious support from you. I suggest you attach a copy of your worksheet so that you can explain where the input cells are and where you want what kind of results. At this point all I can say is that your project "sounds" like it will require VBA.
Variatus (rep: 1143) Nov 14, '17 at 8:13 pm
I suggest looking for a pre-made template online and editing it for your purposes. I feel like there will be something that is a good starting point from Microsoft.
don (rep: 1297) Nov 15, '17 at 6:58 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login