Hi lsy,

You can also explore the functionality of the Advanced Filter (menu
DataFilterAdvanced Filter). You may need to create a criteria range which
should be vertical and include the column header (exactly as in the original
table) and at least one row for filtering criteria for each column you want
filter by. For example:

if your database has the following columns:
ID, Name, Sales, Month

then if you create the following criteria range on the output sheet:
[A1]="Sales"
[A2]=100
[B1]="Month"
[B2]="Jan"

the Advanced Filter output will show all sales higher than 100 in January.

In order to use Advanced Filter on a sheet other than the database, first
activate the destination sheet and then go to menu DataFilterAdvanced
Filter. Chose the "copy to another location" option. Enter the references to
the ranges of the database "List Range" (say Sheet1!A1:D1000), "Criteria
Range" (say A1:B2 in our example) and "Copy To" (say A3 - two rows below the
criteria range) and press OK.

Regards,
KL


"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