OK, you can use the autofilter to filter it, select the area, press f5,
special, visible cells only, copy and past to another sheet.

you can automatic recording a macro.

hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo