Which way did you go? - Was this a one time deal, because once the data has
been transferred you don't need the formulas any more?

Regards
Ken....................


"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