i still not very clear with the solution... what i want is anything key
in in the col3 with the data with ghi in sheet 1 will auto reflect a
record in sheet2... is that possible??


--
lsy
------------------------------------------------------------------------
lsy's Profile: http://www.excelforum.com/member.php...o&userid=23917
View this thread: http://www.excelforum.com/showthread...hreadid=375546