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



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!





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: 2938) 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: 1705) 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