rows to different worksheet

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
>

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
> >
>
>
>

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" <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
>> >
>>
>>
>>

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
>> >
>>
>>
>>