Copying only selected items to another worksheet

  • Thread starter Thread starter firewaterjoe
  • Start date Start date
F

firewaterjoe

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Automatically Transfer Info from one worksheet to another 1
compare and return a value from another worksheet 3
Automatically filling a cell from a worksheet based on a selection 2
The best way to create a Keyword Seach field in excel 1
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
VLook-Up Possibly Conditional Formatting 1
Vlookup issue 2

Back
Top