Hi Antonio

Why not use Advanced Filter and copy the visible cells
to another sheet.

You only have to add one formula in your sheet

See
http://www.contextures.com/xladvfilter02.html



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


"Antonio" wrote in message ...
Tks Ken

Tks for your prompt reply. It does work but my excel worksheet
has now 7 MB and growing... is there any other way to do it?
a macro maybe?

Tks once again for your kind help
António

"Ken Wright" wrote:

You can use VLOOKUP though that will be a lot of formulas and a lot of
overhead, or if you just want all the rows on another sheet, then copy your
sheet in it's entirety, add a helper field that uses a formula such as
=ISEVEN(D1) and copy downa s far as your data goes (assuming your field was
in Col D), then sort on the helper column which will now contain just TRUEs
and FALSEs

Delete the FALSEs and you will be left with what you wanted.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Antonio" wrote in message
...
Hi all

Need help for the following:

Have a worksheet with 3000 rows by 7 columns, filled with numbers that
range
from 1 to 3000. Need a way to move a row to a different worksheet if the
number in one specific cell is either odd or even

Can anyone help?

Tks in advance