This page is dedicated to special search functions for deleting rows.
Delete Rows On All Sheets by String Search
"I have a spreadsheet that has multiple tabs of data, I would like a macro that would either ask for a code
or use the one that is selected which would then run through all the
sheets and delete the rows where that data is shown?"
- Popup message will require user to enter the value to search for
- Popup message will default value on the current cell selection value
- Popup will inquire as to whether WHOLE-CELL only matches are required. If whole cell is NOT required, then rows with "catch" and "scat" would be deleted during a search for "cat"
- Macro will cycle through all sheets
Nothing says "thanks" like a steak dinner!