Excel VBA Invoice Matcher -- 2

I keep one master sheet in Excel that lists every open invoice. When a credit-card payment hits the bank (I import those straight from the downloaded statement), I need a fast way to identify the exact combination of invoice amounts that equals that total. Solver gets me close, but it never lands on an exact match and I’m always left with a few dollars of variance that I have to reconcile by hand. What I’m after is a clean VBA routine—ideally inside the same workbook—that lets me: • Choose or enter the card-payment amount pulled from the statement. • Scan the single invoice sheet and return every set of invoice amounts whose sum matches that figure perfectly (or within a tolerance I can adjust, default zero). • Highlight or list those invoices so I can mark them as paid and attach the payment reference. No other criteria matter for the match; it’s purely the invoice amount. The code must run quickly even when the sheet holds a few thousand rows, and it should remain easy for me to tweak or extend later. Deliverable: a macro-enabled workbook or add-in with well-commented VBA code plus a brief usage note so I can replicate the process on future files. Let me know your turnaround time and fixed price and I’ll get sample data to you right away.

Projekt-ID: 40234008