I am attaching a spreadsheet that I am working on. What I need to do is have all of the information from A17 through F17 in the Monthly report tab populated in the Summary of Payments tab in cells A4:F4 every time there is a payment. Also, every time a new payment is made, that needs to populate one row down in the Summary of payments tab.
For example: In the spreadsheet I am attaching two payments have been made. The payment information for 10/5/2011 should populate in Cells A4:F4, and the information for the payment on 10/8/2011 should populate in cells A5:F5 in the Summary of Payments Tab. etc... This will continue for an entire year's worth of payments.