Hi, I want the name list show up based on 2 conditions.
I link the name it from another file, currently got it to work in the way that if COL B which contain department in another sheet = $D$4 in this sheet show all the name in this department.
However, the second condition is where I stuck, I also want to be able to show the list based all sections in that particular department. In the screen shot if I select section called "admin" in Food and Beverages department (originally from COL E in another sheet) I want the name list to show only name that contain the word "admin" in their position.
Thank you!
The code I have so far
Please Login or Register to view this content.
Bookmarks