Reconciling Multiple Credits to a Single Debit

HAALLLPPPP!

I'm completely new to VBA. Basically, I have a reconciliation spreadsheet that I pull monthly that lists all debit and transactions in the GL for a certain account. I have to go in and match these up. However, the specific account I am working on is large (300+ unreconciled lines) and the debit transactions typically include multiple non-sequential/unequal credits. Is there a faster way that trying to match these up manually? I attempted to use Solver, but my variable range was too large. In the sample I attached, the color coded cells have already been manually matched up.