Copying only selected items to another worksheet
 

I have an extensive price list w/ three columns: Part#, Description, and
Price. I would like to be able to place an 'x' before only items I need and
have them be copied to an 'Order' worksheet.

Copying only selected items to another worksheet
 

If i understand correctly, put an x in column d for the ones you want.
Then filter (data, filter, auto filter).
In column D, use the drop down filter to show only those with X

Copy and paste from there.

Remember to put column headers on before you filter


--
Rob Gaffney


"firewaterjoe" wrote:

I have an extensive price list w/ three columns: Part#, Description, and
Price. I would like to be able to place an 'x' before only items I need and
have them be copied to an 'Order' worksheet.