Macro sum between all positive and negative entries to reach a value

[hstef]

Hi,

I have a column (L) with some negative and positive entries (invoices value).
I have some customers who pay thru bank and does not specify which invoices is paying. And usually do not pay in order.
All i have is paymant's total value.

I need a macro to make calculation in column "L" until it reaches the total value of payment and to highlight the cells that made up the value.
I will put the payment value in "O1".

Column L example:

203.49
224.91
-224.91
239.67
-36.48
-203.49
64.26
-66.96
24.99
-24.99
105.43

<colgroup><col></colgroup><tbody>
</tbody>

Can this be done?
Thank you kindly,
Stef.

 

[Jon von der Heyden]

Here's how the results look:
Excel 2010

Row\Col	A​	B​	C​	D​	E​	F​	G​	H​
1​	Vals	+ Count	- Count	Instance	Match		check	(0.00) ​
2​	203.49​	1​	1​	1​	TRUE​
3​	224.91​	1​	1​	1​	TRUE​
4​	(224.91) ​	1​	1​	1​	TRUE​
5​	239.67​	1​	0​	1​	FALSE​
6​	(36.48) ​	0​	1​	1​	FALSE​
7​	(203.49) ​	1​	1​	1​	TRUE​
8​	64.26​	1​	0​	1​	FALSE​
9​	(66.96) ​	0​	1​	1​	FALSE​
10​	24.99​	1​	1​	1​	TRUE​
11​	(24.99) ​	1​	1​	1​	TRUE​
12​	105.43​	1​	0​	1​	FALSE​

Sheet: Sheet1