yogyata26
02-18-2019, 01:18 AM
Hi,
In my workbook I have 2 sheets - 1st sheet has the case and 2nd has the solution of how the case should look like after running the macro.
In sheet - "CASE" I have 2 sets of data namely Data 1 - Invoices & Data 2 - Receipts.
I need a code which would 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.
Thanks in advance!
In my workbook I have 2 sheets - 1st sheet has the case and 2nd has the solution of how the case should look like after running the macro.
In sheet - "CASE" I have 2 sets of data namely Data 1 - Invoices & Data 2 - Receipts.
I need a code which would 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.
Thanks in advance!