| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to delete unwanted data
I want to delete all part numbers 'PRGM - PTLST1RD'
Thanks for your help Part Number Description Qty Whse Qty Truck Cost PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC CEXE1H101A IC 1 0 0.42 CEXP2E331F 330MF C ELECTRO 1 0 4.68 DCT814A IC101 3 0 19.96 DECAKIT011 DAEWOO KIT FOR TV 7 0 1.22 PJCTCYMN06 VIDEO HEAD 2 0 42 PVPRSWL051 PCB PREAMP 1 0 22.5 RV5417103 BUTTON SUB FOR 4 0 0.5 RV5426102P R SEMI FIXED 1 0 0.51 RV5426103P HORZ CENTER CONTROL 1 0 0.5 TKSC5021FR Q 804 2 0 7.71 T2SD1880 TRANSISTOR 1 0 5.17 48BON0218B REMOTE 1 0 13.43 48B0N2118C REMOTE 1 0 18.11 4850A13440 ANT CONNECTOR 1 0 3.96 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro to delete unwanted data
I'd select that column and do Data|Filter|autofilter.
Then filter to show the rows that equal (or contains) that string. Then select those visible rows and delete them. pm wrote: I want to delete all part numbers 'PRGM - PTLST1RD' Thanks for your help Part Number Description Qty Whse Qty Truck Cost PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC CEXE1H101A IC 1 0 0.42 CEXP2E331F 330MF C ELECTRO 1 0 4.68 DCT814A IC101 3 0 19.96 DECAKIT011 DAEWOO KIT FOR TV 7 0 1.22 PJCTCYMN06 VIDEO HEAD 2 0 42 PVPRSWL051 PCB PREAMP 1 0 22.5 RV5417103 BUTTON SUB FOR 4 0 0.5 RV5426102P R SEMI FIXED 1 0 0.51 RV5426103P HORZ CENTER CONTROL 1 0 0.5 TKSC5021FR Q 804 2 0 7.71 T2SD1880 TRANSISTOR 1 0 5.17 48BON0218B REMOTE 1 0 13.43 48B0N2118C REMOTE 1 0 18.11 4850A13440 ANT CONNECTOR 1 0 3.96 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro to delete unwanted data
Thanks Dave. That was much easier.
"Dave Peterson" wrote: I'd select that column and do Data|Filter|autofilter. Then filter to show the rows that equal (or contains) that string. Then select those visible rows and delete them. pm wrote: I want to delete all part numbers 'PRGM - PTLST1RD' Thanks for your help Part Number Description Qty Whse Qty Truck Cost PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC PRGM - PTLST1RD S SERVIC CEXE1H101A IC 1 0 0.42 CEXP2E331F 330MF C ELECTRO 1 0 4.68 DCT814A IC101 3 0 19.96 DECAKIT011 DAEWOO KIT FOR TV 7 0 1.22 PJCTCYMN06 VIDEO HEAD 2 0 42 PVPRSWL051 PCB PREAMP 1 0 22.5 RV5417103 BUTTON SUB FOR 4 0 0.5 RV5426102P R SEMI FIXED 1 0 0.51 RV5426103P HORZ CENTER CONTROL 1 0 0.5 TKSC5021FR Q 804 2 0 7.71 T2SD1880 TRANSISTOR 1 0 5.17 48BON0218B REMOTE 1 0 13.43 48B0N2118C REMOTE 1 0 18.11 4850A13440 ANT CONNECTOR 1 0 3.96 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to delete unwanted sheets | Excel Discussion (Misc queries) | |||
| Deleting unwanted data by macro or... | Excel Discussion (Misc queries) | |||
| How do I delete unwanted extra pages on Excel worksheets | Excel Discussion (Misc queries) | |||
| Delete unwanted page breaks. | Excel Worksheet Functions | |||
| Delete Unwanted Data | Excel Discussion (Misc queries) | |||
Linear Mode
