I have an excel spreadsheet that has around 1000 rows. Most of these rows will contain nothing of value to my task. ~ 30 will and I only want to keep those 30. I know I can find rows based on some criteria. But I would like to use the list of keys for the rows I want to keep, and delete all of the other rows for the worksheet. kind of "like a find when not in" logic?? Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
delete rows from a worksheet that dont exist in a list
- Thread starter pms18066
- Start date
Chance1234
IS-IT--Management
take a look at
You could adapt that code to fit in with your criteria.
Chance,
Filmmaker, gentleman and ROMAN!
You could adapt that code to fit in with your criteria.
Chance,
Filmmaker, gentleman and ROMAN!
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question