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!