I want to have a user enter a number in a box and then have Excel update
results for that many rows of results automatically.

As a more concrete example, consider an Excel mortgage worksheet where the
user enters the number of years of his/her mortgage into a box and Excel then
calculates the remainder of principle for each year inbetween. So if the
user entered 15 years, e.g., then Excel would print 15 rows of calculations,
each row containing remaining principal information for that year. If the
user then changed the input to 30 years, then 30 lines of information would
be printed. (I'm not asking about the mortgage calculations; I'm just asking
how to get Excel to automatically produce a set number of lines of any output
given a user's input).

Thanks,

Aaron