Delete entire row if cell contains the string X
excel, excel-2007, excel-2010, vba
Solution
This is not necessarily a VBA task - This specific task is easiest sollowed with Auto filter.
1.Insert Auto filter (In Excel 2010 click on home-> (Editing) Sort & Filter -> Filter) 2. Filter on the 'Websites' column 3. Mark the 'none' and delete them 4. Clear filter
Problem
I am trying to come up with a way to delete all rows (and shift cells up, if possible) where the website column cell contains the word `none`. The table contains 5000+ records and this would save me a great amount of time. I appreciate any suggestions.