Dear all big brothers and sister,
I receive the pivot tables from data integration department every week. How can I use macro to choose specific account managers?
In the actual file, there are more than 1000 account managers in the department. my team has 200 account managers
However, my team superviosr only want to see the data of specific account managers.
Can macro help me to chose several specific account manager's name? For example, this week, I only need Adam Singer and **** Lau. Next week, if gordon lau joined our team, is there any user-friendly macro for me to choose the account manager's name.
Thank you
Bookmarks