I have 130 tenants that I am keeping track of there maint. fees for our condo subdivision. I have them listed in a excel work book by Lot Numbers 1-130. Beside the Lot Number is there name in the next column.ending Balance from previous month in next col,Deposit Date in next,Ck. No. 1 in next, Amount Paid in next, Deposit Date 2 in next, Ck. No. 2 in next, Amount Paid in next, Monthly Assement, Total Paid, and last col. Ending Balance. I would like to know how I can give each tenant a Annual Summary of there payments with check numbers and amount paid (if possible with a Ending Balance for there year . I assume it has to do with my Advanced Filter option but not sure how to do it.