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

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

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