Delete all rows except

**bjcowen9000** · 11-14-2017, 06:44 PM

Hi I want to do this over all my worksheets, not just the current acting one.

How can I delete all rows if the first cell is not a multiple of 500?

So if A1 is 500, then row A stays.

If B1 is "Modfiy", then row B is deleted. How can I do this?

**alansidman** · 11-14-2017, 07:30 PM

dupicate posting. I am closing this post, you may continue in your original post

https://www.excelforum.com/excel-pro...-contains.html

Delete all rows except

LinkBack

Thread Tools

Display

Delete all rows except

Re: Delete all rows except

Thread Information

Users Browsing this Thread

Similar Threads

Delete All Rows Below Criteria in Col A / Then Delete Specific Rows in Col E

[SOLVED] Delete blank rows between data rows, shift rows up, then repeat

Scan rows for duplicate column values, then add rows together and delete unused rows.

Macro to delete certain columns and delete rows based on time in another column

delete duplicate rows, delete empty rows

Delete Rows by Cell Value - Delete sheets w/out prompt

Delete & Merge Columns,Delete Rows with filter, etc

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions