Hi Wizards,
I need a simple code needed for the example below:
Range1 (approx 375)
30-01-2006 xx1 220
15-02-2006 xx2 100
Range2 (approx 6000)
15-01-2006 xx1 120
18-01-2006 xx1 60
15-02-2006 xx2 40
now, month & xx1 has to be compared from Range1 into Range2
it is found in 2 rows, so 120 & 60 has to be written next to 120 & 60 again
and a row has to be inserted next to value 60. Then Balance 80
(220-120-60=80) has to be noted in cell next to 220 in range1

Result to like...
Range1
30-01-2006 xx1 220 40
15-02-2006 xx2 40 60

Range2
15-01-2006 xx1 120 120
18-01-2006 xx1 60 60

15-02-2006 xx2 40 40

hope I explained / confused well.

Hoping to get instant reply for this typical rquirement. Thanx a million.