View Single Post
  #1   Report Post  
dguest dguest is offline
Junior Member
 
Posts: 1
Default Delete Rows in A column not Containing multiple text criteria

I have been searching the net with no luck for finding VBA coding that will delete rows where the text in column A does not contain certain text.

I have a spreadsheet which has a header row at row 4 and the data starts from row 5. I need all rows in column A not containing the following text to be deleted:

MGTADM
PRJSTR
PRJCON
PRJCLS
SUPSRV

I found VB for containing text but not for not containing text. Can anyone help as I'm starting to get a little confused with all the codes I've found!

Thanks!