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!!

Attached Files

	Bank Transactions.xlsx (9.4 KB, 11 views)
	Donors.xlsx (10.2 KB, 10 views)
	Ledger.xlsx (9.6 KB, 9 views)