OK I think the following will work for you - I hope so, because it took rather more time than I had intended.

The attached workbook 'Process.xlsm' contains all the code required to process your bank statements (provided they are in the form of your sample). Open the template (you can save it as an add-in if you wish) and you will find a button on the Add-ins tab of the ribbon which has two options.

One will import your bank statement into the ledger, with the appropriate percentages logged. The details regarding the three workbooks and their associated worksheets are stored in the registry and restored next time the function is used. You only need to select the next bank statement for processing. I have allowed the process to reload the bank statement next time, with the assumption that you might use the same file each time but with different contents. If that is not the case you can modify the code so that it doesn't recall the bank statement file.

The other button will clear the settings from the registry.

If you already have a large number of entries in the ledger (as the code assumes a new ledger) then you can adapt the same core function to grab the percentages, but I haven't done that for you).

I have not corrected for a bank statement that contains a name that is not in the Donor's list.

Attached Files

	Process.xlsm (64.8 KB, 10 views)
	Ledger.xlsx (8.2 KB, 10 views)

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com