extracting rows/columns

Can you extract rows/columns out of one worksheet into another?

We have a worksheet that is mixed with our products from Pass & Seymour (PS)
and OnQ/Legrand (ONQ). We want to put the OnQ info into another worksheet
seperate from Pass & Seymour. Is there a way this can be done instead of
going through the rows and cutting & pasting.

Thanks.

You'll have to specify the criteria upon which your data can be
distinguished between PS & ONQ.

Cheers,
--
AP

"Tiffani" <Tiffani@discussions.microsoft.com> a écrit dans le message de
news:104B9E62-0F7D-4E42-833B-26CDC0C3EE5B@microsoft.com...
> Can you extract rows/columns out of one worksheet into another?
>
> We have a worksheet that is mixed with our products from Pass & Seymour
(PS)
> and OnQ/Legrand (ONQ). We want to put the OnQ info into another worksheet
> seperate from Pass & Seymour. Is there a way this can be done instead of
> going through the rows and cutting & pasting.
>
> Thanks.

I would copy the whole sheet over, then sort, then delete the block I didn't
want....

Vaya con Dios,
Chuck, CABGx3



"Tiffani" wrote:

> Can you extract rows/columns out of one worksheet into another?
>
> We have a worksheet that is mixed with our products from Pass & Seymour (PS)
> and OnQ/Legrand (ONQ). We want to put the OnQ info into another worksheet
> seperate from Pass & Seymour. Is there a way this can be done instead of
> going through the rows and cutting & pasting.
>
> Thanks.

Check Debra Dalgleish's website:
http://www.contextures.com/xladvfilter01.html

and find this section: Extract Data to Another Worksheet

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Tiffani" wrote:

> Can you extract rows/columns out of one worksheet into another?
>
> We have a worksheet that is mixed with our products from Pass & Seymour (PS)
> and OnQ/Legrand (ONQ). We want to put the OnQ info into another worksheet
> seperate from Pass & Seymour. Is there a way this can be done instead of
> going through the rows and cutting & pasting.
>
> Thanks.