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!
Bookmarks