I use a template in workbook “Record of payments” to issue receipts, no problem there, but to make life easier I want to:

1. Open the debtor’s account (workbook) in the folder named “Debtors” (let’s say account
LEK-157) entered in range F7 of the template. “Record of payments” and the folder
(“Debtors”) with the debtor’s accounts are in the same main folder named “Office”;

2. Transfer the date, receipt number and amount paid from the receipt template to the next
available row of LEK-157’s worksheet named “Payments received” (date column A, receipt
number column B and amount column C);

In LEK-157’s “Payments received”-worksheet the amount paid is divided between capital (column D), interest (column F) and commission (column G) - no problem.

3. Copy the the row with date, receipt number, amount, capital, interest and commission paid
from LEK-157 to the next available row in “Record of payments”- workbook’s worksheet
named “Daily payments”. The columns of “Daily payments” are identical to the columns of
the debtor’s account’s “Payments received”.

4. Clear the template (no problem) and start with a receipt for account MAN-017 to repeat the
process.

At this moment steps 1, 2 and 3 are manually done.

Your help will be much appreciated.