once again new to excel. looking for help on drop down list. I want to have a drop down list on sheet 2 that says monthly, bi-weekly and weekly payments. When I choose 1 of them items from a list it takes payment amount, interest, principle and # of payments from sheet 1 and puts it in 4 lines below the item on sheet 2 where the drop down list is. Sheet 1 is a loan calculator and sheet 2 is a amortization schedule that can take the values from sheet 1. sheet 2 you can choose if it is a monthly, bi-weekly or weekly payment and automatically put the values in. Hope this makes since.