I am attempting to completely automate a process in excel so that anyone could use it.

I currently have a table that gives the duration of a lease, the number of periods remaining and the risk free rate for that specified lease.

I have been searching forever for a solution but I cannot seem to find it. For example, I have total periods remaining of say 48 months. What I need is for when the number 48 is typed, that a table will then populate with 48 rows. The number of rows is variable but the number of columns will always be 9.

I have no experience with VBA, but I have also tried to sort through some examples on the web for how to do this, but have not been successful.

I am not even sure that this exists but I thought I would ask anyways.

Thanks!