Filtering multiple items in a pivot table (from arrays)

[danf_cardenas]

Hi!

I need your support guys, in a big file I am working on I have the following table:

[TABLE="width: 249"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Group[/TD]
[TD]Dept[/TD]
[TD]Owner Name[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]Adam[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]B[/TD]
[TD]Alex[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]C[/TD]
[TD]Bryce[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]D[/TD]
[TD]Carmen[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]E[/TD]
[TD]Eric[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]F[/TD]
[TD]Giovanna[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]G[/TD]
[TD]Jane[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]H[/TD]
[TD]Manuel[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]I[/TD]
[TD]Robin[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]J[/TD]
[TD]Rocio[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]K[/TD]
[TD]Tabba[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]L[/TD]
[TD]Tom[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]M[/TD]
[TD]Chris[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]N[/TD]
[TD]Matthew[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]O[/TD]
[TD]Gus[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]P[/TD]
[TD]Fer[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Q[/TD]
[TD]Marilina[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]R[/TD]
[TD]Hector
[/TD]
[/TR]
</tbody>[/TABLE]


There are only 4 Groups (Column A) and different departments (Column B)... Right now, I have code that saves me each one of the departments in arrays:

Group1(20)
Group2(20)
Group3(20)
Group4(20)

Now that I have all the departments in "Group" arrays, I need your help so I can filter a pivot table with only the departments inside a "group"/array (Then it sends a mail, but I have this part figured out) and then repeat for each one of the "Groups"/arrays.


If you need me to post more info, please let me know...

Thanks!!