I'm trying to work with a large Excel sheet that is auto updated and each time I have to open the new updated file. I have to review sales reps orders about three times a week. And I need to be able to highlight or sort by a set list of sales rep names that I keep in a separate Excel sheet on my computer (if possible).

I've looked at conditional formatting, but I need to be able to include a list of 5-50 sales reps. And I don't know enough about Macros or VB to solve this problem on my own. Please let me know if there is any other information that is needed from me.

Thank you in advance for any help that you can provide!