Thread: [Solved] Macro to delete rows not containing specific text
View Single Post
 
Old 02-02-2017, 10:03 AM
Alimou Alimou is offline Windows 8 Office 2013
Novice
  
Join Date: Jan 2016
Posts: 4
Alimou is on a distinguished road
Default Macro to delete rows not containing specific text
Hi,
I'm new to the forum...

Would anyone help me with a macro that:
1. Loops through all sheets in a workbook
2. Delete all rows in each sheet which don't contain 'Country', 'Spain' and "" (empty spaces) - The column to look for the values is column B in all sheets
3. Save the workbook as 'Spain.xls'

Many thanks

Ali
Reply With Quote