David,

You can use an event. For example, the code below will copy row 5 down for enough rows to match the
number entered in cell C2. This assumes that Row 5 has the formulas needed to created the
amortization table.

Copy the code, right-click the sheet tab, and select "View Code", then paste the code in the window
that appears.

HTH,
Bernie
MS Excel MVP

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$C$2" Then Exit Sub
Application.EnableEvents = False
Range("6:65536").Clear
Range("5:5").Copy Range("5:" & Target.Value + 4)
Application.EnableEvents = True
End Sub



"David Treptor" wrote in message
...
I am creating a Loan Amortization schedule and would like to configure it to
autmatically populate the list of periods based on the number of periods in
the loan. Is this possible, and if so, how would one do it. Thanks.