Look at advanced filter in help, it does what you want.

Or take a look at http://www.contextures.com/xladvfilter02.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"sebas" wrote in message
...
hi, first of all i don't know if it's possible to do this with excel....

i have a liste wich have 4 colums
column 1 article number and name (AAA-305 - cli- a/c keeprite)
column 2 article selling price (500.00$)
column 3 article cost price (250.00$
column 4 article last change date

i have about 2000 items on this list and want to be able
to print just 500 items

how could i have the selected lines transferd to another page to be
printed
as another list

--
thanks