Thanks very much, Graham, for your response and suggestion. That has been very helpful.
But because we would normally be collecting information about new donations from Bank statements downloaded from the internet, we would be populating the first 3 columns in your Ledger.xlsm from that source, rather than manually entering each donation as it is received. Is it possible to adapt what you have created to fill the 'project' columns automatically once data is entered into the first 3 columns? That would achieve what we would be looking for.
I look forward to hearing from you again.
|