Macro to delete rows not containing specific text

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Macro to delete rows not containing specific text

FAQ

Thread Tools

Display Modes

02-02-2017, 10:03 AM

Alimou

Macro to delete rows not containing specific text

Windows 8

Office 2013

Novice

Join Date: Jan 2016

Posts: 4

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to delete text in specific styles	ljd108	Word VBA	14	01-22-2019 01:22 PM
Macro to delete text from cells with specific format	Soenke	Word VBA	4	09-01-2016 08:55 AM
Macro to delete all empty rows from all tables	braddgood	Word VBA	15	10-02-2015 01:54 PM
Macro to conditionally delete rows	Steve_D	Excel	2	08-24-2012 09:37 PM
Macro to delete rows with all empty cells	ubns	Excel Programming	2	08-14-2012 02:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:18 PM.