I have a spreadsheet having two ranges (1) deduction range (2) remittance range
since remittance is not made correctly I need to match remitance to
deduction range (FIFO method) and insert a row in the deduction range, if
required. sample as follows. ie c1 the first remittance is Rs 200 to be
matched with ded (d1 to d4), but for d4 is short by 50 which will be matched
with c2 remittance. similarly c2 Rs 300 will be matched with d4 to d6 and
short will be matched by c3, like wise.
DEDUCTION RANGE
MONTH DED REF DED REMIT REF MATCHED REMIT AMT
JAN D1 25 C1 25
JAN D2 50 C1 50
JAN D3 75 C1 75
JAN D4 100 C1 50
JAN D4 C2 50
FEB D5 125 C2 125
FEB D6 150 C2 125
FEB D6 C3 25
FEB D7 175 C3 175
MAR D8 200 C3 200

REMITANCE RANGE
S No REMIT REF REMIT AMT
1 C1 200
2 C2 300
3 C3 400

I have approx.6000 rows to match for 375 rows

Thanks in advance.