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