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.
|