Selecting Rows based off certain criteria and deleting all others
 

Hi all,

I have a large population of data that needs to be sorted by certain
criteria, and I'm not all too great with macros, so if anyone could please
assist, that'd be great.

All I need to do for right now is remove all the rows that have no
highlighting in any of the columns. I've already gone through and
auto-filtered certain values that need to be analyzed, but there are
thousands of rows that didn't meet any of the criteria, so I'd like to remove
them. Is there a simple macro I can run that will search all 7 columns of
each row, and if none of them are highlighted, they will be deleted?

Thanks,

Jonathan

Selecting Rows based off certain criteria and deleting all others
 

Also, if possible, I'd like to add a function where, for each row that has a
highlight, creating a new column and saying what the top row (column name) is
so I can see which row is being pulled for what column being highlighted.
(Example, if Rules 3 and 4 are the ones highlighted, it would create a new
column that would say "3,4"

"Jonathan" wrote:

Hi all,

I have a large population of data that needs to be sorted by certain
criteria, and I'm not all too great with macros, so if anyone could please
assist, that'd be great.

All I need to do for right now is remove all the rows that have no
highlighting in any of the columns. I've already gone through and
auto-filtered certain values that need to be analyzed, but there are
thousands of rows that didn't meet any of the criteria, so I'd like to remove
them. Is there a simple macro I can run that will search all 7 columns of
each row, and if none of them are highlighted, they will be deleted?

Thanks,

Jonathan