Hi Juuljus,

Consider using Excel's Autofilter or Advanced Filter features.

If you want to automate this, turn on the macro recorder while you perform
the rquisite steps. The resultant code may be edited to provide more general
application.

If you adopt the Advanced Filter approach, bear in mind that the filter
should be invoked from the destination sheet.

If you experience problems whilst editing your code, post back with
specifics.


---
Regards,
Norman


"Juuljus" wrote in message
oups.com...
I'm struggeling with a search.
How can I select all the rows, that meet a certan criteria and and copy
then into another workbook. And then from those rows select a certan
coloumns (again that meet a certan criteria).

Thanks, Juuljus