Allocating amount with invoices for each customers in separate sheets

[yogyata26]

Hi

I have a macro which used to allocate the receipts with invoice amount using FIFO method.
This macro used to work when I had Invoices and receipts in the same sheet and also it was limited to one customer.

Now, in my new workbook I have separate sheets for Invoices (Sheet 'Inv') and receipts (Sheet 'Rec').
I want a macro which would allocate the receipts with invoices for each customer in separate sheets using the same method!

The output should be generated for each customer separately based on the format in 'Template' sheet.

The 1st row in 'Template' sheet shows from which sheet and column the values will be pulled.

An example of the output for customer A is in sheet 'A'.

I have attached 2 workbooks :
1. "Old Sample" which has a macro.
2. "New Sample" in which I want the code to be written

Thanks in advance!

[sebastiand95]

*Wrong reply. Deleted*

[yogyata26]

If any additional information is required or if the description is unclear please let me know!

[AliGW]

Closed at the OP’s request - there will be a thread in Commercial Services instead.