"lsy" wrote:
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??

That's exactly what the suggested construct does !

Here's a sample file with the construct implemented:
http://flypicture.com/p.cfm?id=56960

(Right-click on the link: "Download File"
at the top in the page, just above the ads)

File: lsy_wksht_1.xls

Play with the file. Try adding further to the sample data in Sheet1. The
results will be updated in Sheet2 automatically.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----