bilbo85
09-12-2017, 04:13 PM
Hi,
I have a random amount in cell A1 (e.g. 50,000) and a list of invoice numbers in column B and their corresponding amounts in column C.
I am after some VBA that can identify and list all possible combinations of invoices that total the target amount of 50,000.
Any idea how to do this please?
Thanks in advance.
I have a random amount in cell A1 (e.g. 50,000) and a list of invoice numbers in column B and their corresponding amounts in column C.
I am after some VBA that can identify and list all possible combinations of invoices that total the target amount of 50,000.
Any idea how to do this please?
Thanks in advance.