Perhaps something along these lines ..

In Sheet1, data is assumed in cols A to D, from row1 down
with the key column being col C

Put in say, F1: =IF(TRIM(C1)="","",IF(TRIM(C1)=Sheet2!$X$1,ROW()," "))
Copy F1 down to say F100, to cover the max expected data in col C

In Sheet2
------------
Let's reserve X1 for input of the item of interest
Input in X1: ghi

Put in X2:
=IF(ISERROR(SMALL(Sheet1!$F:$F,ROWS($A$1:A1))),"", INDEX(Sheet1!C:C,MATCH(SMA
LL(Sheet1!$F:$F,ROWS($A$1:A1)),Sheet1!$F:$F,0)))

Copy X2 across to Y2, fill down to Y101
(cover the same range as in col F in Sheet1)

For the input in X1,
you'll get the desired filter results in cols X and Y, from row2 down

And the results in Sheet2 will auto-update for any subsequent changes (e.g.:
new data input) made within Sheet1's col C
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"lsy" wrote in message
...

In excel there is a fucntion that can filter particular data in the
current page... but can i filter and display in another page!!

example sheet1:
Col1 Col2 Col3 Col4
abc def ghi jkl
bbb ddd ggg jjj
bac fed ghi klj

eg sheet2:
ColX ColY
ghi jkl
ghi klj

so if i have a new data enter in Col3 as ghi in sheet1 then sheet2 will
auto have that new record in ColX n ColY!! that is something like
linking 2 sheet..


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