Hi All

I would appreciate you help on the following problem.

I have two workbooks each having power Pivot Tables on them. From workbook1 user is presented with a choice of which salesperson's report they want to open. What I need is a code that based on Selection in workbook1 then Workbook2 will open and the slicers in Workbook2 will have the correct name already selected that matches the selection in workbook2. I have the coide which opens the report in WB2 but not sure how to pass the sleection from Combobox in WB1 to WB2's slicer. I.e. if user selects John in WB1's ComboBox then WB2 will open and the slicer value for name will be set to John so only John's data is visible.

Is this possible at all?

Thanks in advance