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