Hello all,


New to the group and was looking for some formatting help. I have a
rather extensive financial model that covers approximately 400-500 rows

on the inputs sheet. I'd like to set up a separate input that will
consolidate unused rows / columns. For example, the model enables a
user to input up to 5 types of capital investment, if a specific user
only has 1 type I'd like them to be able to type "1" in an input cell
and the required number of rows automatically appear. This way, they
are not staring at 300-400 rows that they are now even using.


I'm a fairly advanced excel user and have explored options with
conditional formatting as well as outlining but have not come up with a

solution. I'm sure the answer is simple, I'm just not finding it.


Certainly, if there are alternative solutions I'm open to suggestions.