software

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

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

Thanks.

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

Cheers,
--
AP

quot;Tiffaniquot; gt; a écrit dans le message de
...
gt; Can you extract rows/columns out of one worksheet into another?
gt;
gt; We have a worksheet that is mixed with our products from Pass amp; Seymour
(PS)
gt; and OnQ/Legrand (ONQ). We want to put the OnQ info into another worksheet
gt; seperate from Pass amp; Seymour. Is there a way this can be done instead of
gt; going through the rows and cutting amp; pasting.
gt;
gt; Thanks.
I would copy the whole sheet over, then sort, then delete the block I didn't
want....

Vaya con Dios,
Chuck, CABGx3
quot;Tiffaniquot; wrote:

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

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

and find this section: Extract Data to Another Worksheet

Does that help?

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

XL2002, WinXP-Proquot;Tiffaniquot; wrote:

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