Variable autofilter

[phalcon45]

Is there a way to set a filters criteria based on a list of variables?
I have a master list of names of all employees. Some employees get reassigned to new areas on a regular basis. I get schedule updates from their supervisors each week. The list of employees by each area changes.

What I'd like to do is take the employee list I get from each area and have excel automatically set a filter based on that list (could be anywere from 2 to 120 people depending on the area). Then I do what I need to for those employees, then I'd like to have excel autofilter based on the next list.

In short, is there a way to have the filter criteria list set dynamically?

Thanks in advance

 

[DanteAmor]

It can be with Advanced Filter.
- In a column, eg. column "G". Add the names of employees.
- Select data, eg. A1:D17
- On the Data tab, in the Sort & Filter group, click Advanced.
- Click in the Criteria range box and select the range G1 to G (and the last row with names). eg. G1:G4
- Click OK.


Important, the title in cell A1 and G1 must be the same.

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:29.47px;" /><col style="width:29.47px;" /><col style="width:76.04px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; ">NAMES</td><td >DATA</td><td >DATA</td><td >DATA</td><td > </td><td > </td><td style="background-color:#ffff00; ">NAMES</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >name1</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td >name1</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >name2</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td >name3</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >name3</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td >name5</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >name4</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >name5</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >name6</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >name7</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >name1</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >name2</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >name3</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td >name4</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td >name5</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td >name6</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td >name7</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td >name1</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td >name2</td><td >data</td><td >data</td><td >data</td><td > </td><td > </td><td > </td></tr></table>

---------------------
Result:


<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; ">NAMES</td><td >DATA</td><td >DATA</td><td >DATA</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >name1</td><td >data</td><td >data</td><td >data</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >name3</td><td >data</td><td >data</td><td >data</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >name5</td><td >data</td><td >data</td><td >data</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >name1</td><td >data</td><td >data</td><td >data</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >name3</td><td >data</td><td >data</td><td >data</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td >name5</td><td >data</td><td >data</td><td >data</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td >name1</td><td >data</td><td >data</td><td >data</td></tr></table>

 

[phalcon45]

FANTASTIC!
I cannot thank you enough

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.