I'm hoping someone more knowledgeable than I with excel will be able to help me speed up my daily work a little bit.
Every day I have to send a couple of different sales reports to my manager. Essentially it indicates how much money has been brought in so far for the week.
Currently, I'm using a pivot table to format, and filter out any employees who do not apply to the sales report I'm sending (The raw data I use includes sales for every sales rep in every department in the company, and I only need x amount of reps in x amount of departments.) which works fine, however some of the teams I'm pulling numbers for have over 20 agents. It takes time to check, and double check through the pivot table and make sure I include them, and not someone with a similar name.
So what I want to do, is before I pivot the data, filter out any rows that do not include the names of the agents I want.
So essentially, delete any rows that do not have "John Smith" "Jane Doe" or "Dio" in Column K.
Not as effective as just being able to say "delete everyone but x y and z", Couldnt you just sort by column k and delete around that within the department?