hi matthias

See
http://www.rondebruin.nl/copy5.htm

Or use EasyFilter
http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"matthias" wrote in message ups.com...
Hi guys,

i would like a macro to do the following: i have a database with 2000
lines and 50 columns.
the macro should copy all the rows that fulfill the criteria that the
37th column=1 , to a new worksheet.

can anyone help me?

thankx