Pivot Table - Show Details VBA - Multi Row and Column

Nilous

New Member
Joined
Jan 24, 2017
Messages
5
Hello,

I need assistance, please!

I have an excel document that has multiple worksheets. On one of the worksheets, I have multiple pivot tables that are manually created, based on the data being used. The primary use for this document is to take a "Big Data" file and provide the "customer" with easy to read results.

My question is....how do I create a macro to provide the details of a pivot from another worksheet.

Ex: Worksheet 1 provides details from Worksheet 2 based on the pivots that have been created. On Worksheet 1 it would show all the results of the Pivot totals. If I'm on Worksheet 1 and I double click the cell where the result...I would like to show the details that make up the total. So if Worksheet 1 shows 42, when I double click on that I would like to have a new sheet open with what is making up that total of 42.

I hope this makes sense, its hard to explain.

I have attempted to record the macro but it seems I need to record one for every click. I am hoping there is a VBA code that can just show detail based on the results being shown. If I click the 42 on Worksheet 1 I would like the Macro to know the location and then just provide the pivot details on what makes up that 42.

I've been working on this for days and I can't seem to figure it out. Please, experts, help me become better! :)

I have attached screenshots to help explain what I am trying to do.

WORKSHEET 1: https://www.dropbox.com/s/va9teu0hm1tvn2i/Worksheet_1_(Analysis_Results).png?dl=0
WORKSHEET 2: https://www.dropbox.com/s/07lo9gm83ddrtie/Worksheet_2_(Pivots).png?dl=0
 
Last edited by a moderator:

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Forum statistics

Threads
1,224,823
Messages
6,181,178
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top