Hi. I need help on a vba code for my work project, see attached sheet. What I basically needs assistance is creating a macro that:
1.) based on user (I've already created a userform) is to filter sheet "MASTER" based on criteria (user and corresponding dept).
user dept
JOEL ----> all (no filter)
CHING ----> OSAA "AND" PROPER
PAU ----> LEGISLATION
BERNS ----> EAR
2.) filter Sheet ("MASTER") based on #1 until lastrow
Column B Column I
EMPNAME OFFICE
REMIGIO, JACOB A. ----> LEGISLATION
MALINAB, CONCHU D. ----> ADMIN
BARANDA, MARY A. ----> OSAA
HAGURING, LORENA G. ----> OSEC
BALAGNE, MAY H. ----> PROPER
LABERINTO, ELMER C. ----> EAR
LARGOZA, AILEEN G. ----> LEGISLATION
2) Paste the result into another worksheet ("EmpNames") and sort it
3.) Create named range ("MyList) which I refer to on my combo box userform.
What I initially thought of is store the criteria on worksheet change event which then triggers the macro to filter, paste, sort and create the named range. Any help would be greatly appreciated. Thanks in advance for the assistance!
Bookmarks