Excel: Pivot Table Filtering Using VBA/Slicer? -

gold star whoever solves this! :)

i have pivot table has data various attributes attached unique id numbers olap cube report. when select id# pivot field , corresponding attributes ie: name,age,etc end getting 10k id's 10k corresponding attribute values. have list of 3k id#'s want filter report by. best way this?

simple example: pivot table displays id# 1,2,3,4,5 , corresponding attributes such name,age,etc

i want filter id#'s column of values have in worksheet example column in other worksheet have id#'s 1,2,3 (which in theory omit values 4 , 5 pivot)

(keep in mind dealing thousands of rows example made simple explanation)

i thought vba slicer combo might work, have no clue how set slicer when created has values selected column of values.

in example vba slicer have id#'s 1,2,3 selected upon creation or easy way select multiple id#s list or can't feasibly click through 3k values

possible solutions brainstormed

i thinking maybe vlookup or pull id#'s against column , bring corresponding attributes? thing cube report being dynamic , updating slicer.

i thought create slicer based off of pivot table composed of header of id#'s , lists id# 1,2,3 created in worksheet , try , use simple slicer against olap cube, issue slicers have different connections , can't overlap. :(

any , appreciated!!! :)