on previous post please consider past = paste.

sorry

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



"Marcelo" escreveu:

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