View Single Post
  #1   Report Post  
glenlee
 
Posts: n/a
Default 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.