I am trying to help my mother create a document to capture all of her supporters contact information on one sheet, their contribution via check information on another sheet, and be able to have a report showing each check received on another as a receipt at the end of the year.
Sheet 1 capture all of her supporters contact information
Sheet 2 Use a Data Validation(to minimize human typing errors) on sheet two to name the entry of the checks as well as the amount, check number, and any notes on the check.
Sheet 3 will pull information from sheet 1 and 2 to create a yearly receipt (here is the catch) listing each check and its details separately... There could be one check there could be 15...
I had it working fine until I realized using VLOOKUP would only return the first entry found... I don't know if there is an IF previous row = ? then return next entry. Or if there is a index/match/something function that would work... I will attach my current workbook to give you a better idea of what I am doing.
Any information would be most helpful. Thanks you!
Test Account and reports.xls
Bookmarks