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