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" <Antonio@discussions.microsoft.com> wrote in message news:1B95A421-8800-4911-8D5F-42982F031EED@microsoft.com...
> 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" <Antonio@discussions.microsoft.com> wrote in message
>> news:710033EF-0277-47AE-A36C-8DDA5879B4A8@microsoft.com...
>> > 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
>> >
>>
>>
>>