jonespandrew
New member
- Joined
- Jan 27, 2016
- Messages
- 122
- Reaction score
- 0
- Points
- 0
Hi I have two pivot tables however from the on pivot table i want to be able to create a seperate drop down box to select site name and then have it pull the data from selected cells and colums and display it within the same sheet is this possible.
I.e table has colums that say over due and failed if i were to double click on these fields it will open up another sheet displaying the data behind that number.
i want to bring that data into the main sheet but only from selected fields and each time the pivot table is refreshed have that data rereshed as well.
I.e table has colums that say over due and failed if i were to double click on these fields it will open up another sheet displaying the data behind that number.
i want to bring that data into the main sheet but only from selected fields and each time the pivot table is refreshed have that data rereshed as well.