Can Excel link a query or code to pull pivot table report data

Alright, so a many of my Google searches for Excel help usually ended up with me browsing this forum and thus registering to view more. Now, I find myself stuck at a simple question of can Excel perform this function before attempting to post the question of how I manipulate Excel to do this function; however, as I have browsed a large number of threads there was a consistent theme - 'You've broken the rules and we've locked your thread until you acknowledge you've broken the rules and correct it." So, to avoid that I've also got the rules' page open as I type.

I've searched and searched for the answer to my question, and am always returned with the 'getpivotdata' result. However, that's is and isn't what I'm looking for. I have a pivot table that, as in any other pivot table, will pull a data report of the filters when double clicking in the appropriate field. I've used the getpivotdata to locate the value of the filtered pivot table, but I was wondering if I can link the getpivotdata or a vlookup to pull that pivot table's report data for said entry.

I have a search query here:

\1

With database listing on sep tab:

\1

And the Report the Pivot table pulls when double clicking into:

\1

Can Excel link a query or code to pull that pivot table report data, and not just the hard figure, outside of the pivot table itself?

If so, what is the term I am looking for to find myself the answer?

Thank you!

Hi Miskondukt and welcome to the forum,

I'm not sure what the question is, exactly, but it sounds like you want to copy and paste "values only" from a Pivot Table to another region in a workbook. This is pretty common.

If that isn't what you need then we really need a sample workbook with a sample pivot showing what you expect the results to look like.

You can post a sample workbook by clicking on "Go Advanced" below the message area and then on the Paper Clip Icon above the advanced message area to post a sample workbook.

HI,

If you want to double click on Tab DB and then take that expanded data (on this new sheet) and copy and paste it to the Master sheet, you will need to do it using VBA.

I turned on the Macro Record feature and double clicked on N8 on the DB tab and found it created a Sheet1 with the expanded data that resulted in the "17" data.
The VBA code to do this is:
Worksheets("DB").Range("N8").ShowDetail = True

Then using VBA you would need to have something like:

Worksheets("Sheet1").range("B1").Copy Destination:=Worksheets("Master").Range("A12")

I have no idea what you want to copy or paste from the new Sheet1 to the Master so the above is a sample of what I think you might want. Could you be more specific on what you want to end up in A12.