ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Delete Rows in A column not Containing multiple text criteria (https://www.excelbanter.com/excel-programming/445793-delete-rows-column-not-containing-multiple-text-criteria.html)

dguest

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!


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com