I can create a loan excel sheet fast but one thing I need to learn is if the user enters 15 yrs instead of 30 I only want the cells to populate thru year 15.

Typically I create the template and pull the formulas down to year 30, if they enter 15 years all the miscellaneous cells read $0.

Not sure how to tell the program to stop populating after year 15(user input)

Thanks,

ltp