extracting rows/columns

T

Tiffani

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

Ardus Petus

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

Cheers,
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
Top