Thanks for the follow-up.
I am attaching 3 files with made-up data - 'Bank Transactions.xlsx' which contains the raw data downloaded from the Bank, 'Donors.xlsx' which has the information about new Donors (and their instructions for sharing their donations among each of the 5 projects) and 'Ledger.xlsx' which contains the information for all gifts from the Bank and where we want to populate the 'Project' fields with the appropriate share of their donation.
I trust this makes sense and will help you to help me!!
|