Stuck Building A Dynamic Commercial Real Estate Model

Hello,

I built the attached Net Cash Flow model to analyze real estate deals. I am looking to take make it truly dynamic. Right now, it's semi-dynamic and am running into problems developing my ideas. I've attached my current model with notes on the "Rental Assumptions" tab which outlines what I am looking to do. Briefly, (and I'm not sure if this involves macros or not) I am looking to create a box that once a value is selected, a new box appears to add additional values.

IE: the prompt box would be simple and ask "how many tenants the property has" to which you can choose 1-30 from a drop down box. Once a number is selected and you hit enter, a new box appears with the number of tenants you chose to add in the necessary data to fill in the rest of the model with.

I am open to suggestions or paying for further involvement to help bring the model to fruition. Please let me know once you take a look to see if you'd be interested in helping me:

[email protected]