Forum Discussion
Duplicate Invoice & Supplier
Conditional formatting to warn if an invoice has already been entered based on multiple criteria of both the supplier code & the invoice number.
Is this possible?
Based only on the invoice number only is not a problem, but it needs to be able to accept the number duplicate if it relates to a different supplier.
Example: Supplier 1 uses invoice # 002
Supplier 2 uses invoice # 002
These would pass the test as they are different suppliers using the same invoice number,
If Supplier 1 sends a duplicate invoice #002 I need to be alerted that this invoice has already been processed. Any help would be appreciated. VBA or macro would be OK as well.
2 Replies
Malcolm McMaster An easy way to do this would be to add one column that combines the supplier code and the invoice number and then apply standard conditional formatting that highlights duplicates in the entire column. The attached workbook contains an example.
