Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Have 2 items in dropdown, want warning if one selected | Excel Worksheet Functions | |||
Items, when selected doesn't appear!? | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Is it possible to copy only selected items to another worksheet... | Excel Worksheet Functions | |||
selected items flash | Excel Discussion (Misc queries) |