Delete rows based on Column B Values

Hi

I am looking for a macro to delete the entire rows if cells in column B are DC, DTCF, FAS

Column A
Cost Center Digits
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

Column B
CoCd
USA
USA
USA
SVCS
ATR
ATR
DC
TAX
DC
DC
DTCF
DC
DC
DC
ATR
FAS
FAS
TAX
SVCS
DC
DC
DC



Please help.

Regards,
Vijay

Try this:

Please Login or Register  to view this content.