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" a écrit dans le message de
...
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.