Allocate amount based on data

[Sebastian Daniel]

Hi,

I'm trying to look for a VBA where-in I have 2 set of data namely Data 1 - Invoices & Data 2 - Receipts.

The VBA should allocate all the receipts with the Invoices serial no. wise.

If a single receipt is not sufficient to adjust a Invoice, a row is inserted and in that row the remaining balance of invoice is adjusted against next receipt.

I have attached a sample xls for easy reference with the above scenarios.

Thanks in advance!