I'm doing voluntary work for a small charity. We have a list of about 50 donors (with alpha/numeric IDs). They can donate money and spread it between 5 projects by indicating a percentage for each. This information is held in one spreadsheet.
When donations are received they are entered into the Ledger with the date, amount and the donor's ID. Is there any way to automatically populate the following 5 cells (one for each of the projects) with the appropriate amount calculated by reference to the donor's ID and his specified percentage for each project?
I'm not a VB expert so if coding is required I would appreciate some specific guidance.
Thanking you in anticipation.