View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaffnr Gaffnr is offline
external usenet poster
 
Posts: 65
Default 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.