Pivot Table Query.

[AJ_121]

Hi,
I have created an excel which has Multiple Data of Multiple Persons of different days in a Pivot table and I am getting this data one by one on a pivot table by clicking on a Slicer which has a Person name( Person name I made as an identifier in the datasheet ) and then data comes of all days on that pivot table of that one person but I need that without clicking on the Slicer my pivot table should give data when someone types any person name in Cell A1 which data is present in the datasheet.


Kindly someone helps me with it.

 

[AJ_121]

And not only in Single-cell A1, actually, but I am also comparing data of 5 persons simultaneously by selecting Person's name from Slicer therefore I need that if I put 5 names in Cell A1, A2, A3, A4, A5 then data should come without Selecting the name from Slicer. Cell A1, A2, A3, A4, and A5 are automatically generating the names via the VLOOKUP function from the same sheet.