ka123
07-01-2016, 12:26 AM
Hi,
I have built a model which uses array formulas to pull up Invoice IDs and quantities from "Data" tab to "Shipments" tab. Invoice IDs correspond to each Part (Col A) for dates after those listed in Invoice_date column (Col B). This is a multiple occurrence case which continues to look for invoices until we reach the qty specified in Col E of the shipments tab and then moves on to the next line. We can't have any duplicate invoices for each Part (Col A), hence I'm using the last invoice on the row above for the same part as the beginning date for the next invoice. This is resulting in circular referencing and really slowing down the processing.
Can someone please assist me with a VBA macro to tackle this? I have pulled out a few lines as an example in the attached.
Many thanks in advance!
Kay
I have built a model which uses array formulas to pull up Invoice IDs and quantities from "Data" tab to "Shipments" tab. Invoice IDs correspond to each Part (Col A) for dates after those listed in Invoice_date column (Col B). This is a multiple occurrence case which continues to look for invoices until we reach the qty specified in Col E of the shipments tab and then moves on to the next line. We can't have any duplicate invoices for each Part (Col A), hence I'm using the last invoice on the row above for the same part as the beginning date for the next invoice. This is resulting in circular referencing and really slowing down the processing.
Can someone please assist me with a VBA macro to tackle this? I have pulled out a few lines as an example in the attached.
Many thanks in advance!
Kay