Mass Delete Rows with specific phrase

[washburn321]

I have a massive amount of data and want to delete all rows that contain "2007" in any cell in that row. Any tips?

[tigeravatar]

washburn321,

Welcome to the forum. You could use a macro. To add a macro to a workbook:

1. Save a copy of the Excel workbook you want to modify
   • Always test macros in a copy so that the original is preserved in case the modifications don't go smoothly
2. Open the copy of the Excel workbook you want to modify
3. Use the keyboard shortcut ALT+F11 to open the Visual Basic Editor
4. Insert -> Module
5. Copy/Paste the code into that area

To run a macro in a workbook:

1. In Excel (not the Visual Basic Editor) press the keyboard shortcut ALT+F8
2. Double-click the desired macro (I named this one MassDeleteMacro_for_washburn321)

Macro code:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[missyrobert]

Hello, I need to find and delete all rows that contain the words "Job Date:". Can you help me with a macro for that? Thanks!

[kundterra]

Please Login or Register  to view this content.

I guess this will be the formula, based upon the previous macro. Just change the String value.

[missyrobert]

I get a "Compile Error" Invalid outside procedure. I'm a total novice, so please forgive me. I copied the part above starting at "Const" though "xlShiftUp", saved it then ran that macro. Am I even doing that part correctly?

[kundterra]

Yes, that should be correct if you are entering it into an already existing macro.

I just tested the macro, worked perfectly for me.