| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can we delete rows permanently from excel sheet | Excel Discussion (Misc queries) | |||
| In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
| How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
| Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
| How to delete blank rows | Excel Discussion (Misc queries) | |||
Linear Mode
