Need a fast way to delete rows
 

I have 2 Excel files:

1. File showing revenue by salesperson by month (1000 rows)

2. File showing salespeople that need to be removed from File #1 by
specific month. For example, this file would show Joe Salesperson,
June & August. Meaning I only want to exclude his revenue for those
specific months from File #1.

Anybody have a fast, easy way to accomplish this. Sorting and
Filtering is proving time-consuming and tedious. There's got to be an
easier way.

try advance filter and remove visible cells
not tested.

--
remove $$$ from email addresss to send email
============
"glenlee" wrote in message
...
I have 2 Excel files:

1. File showing revenue by salesperson by month (1000 rows)

2. File showing salespeople that need to be removed from File #1 by
specific month. For example, this file would show Joe Salesperson,
June & August. Meaning I only want to exclude his revenue for those
specific months from File #1.

Anybody have a fast, easy way to accomplish this. Sorting and
Filtering is proving time-consuming and tedious. There's got to be an
easier way.