Macro deleting certain cells
 

A1 = D1 - remain unchanged
A2 < D2 - delete A2:C2 & F2:H2 then shift up

A3:C3 will now move up after the deletion and making the comparison
again.

Is this possible? Anyone can help?


--
hanz
------------------------------------------------------------------------
hanz's Profile: http://www.excelforum.com/member.php...o&userid=36059
View this thread: http://www.excelforum.com/showthread...hreadid=558453