• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1069
  • Last Modified:

Extract Data from Pivot Table

Hi here is the link to my spreadsheet posted.

 Your file has successfully been uploaded!
To download the file, you must be logged into EE-Stuff. Here are two pages that will display your file, if logged in:

View all files for Question ID: 19634478
https://filedb.experts-exchange.com/incoming/ee-stuff/4260-Book1.ziphttps://filedb.experts-exchange.com/incoming/ee-stuff/4292-Book22.zip
https://filedb.experts-exchange.com/incoming/ee-stuff/4315-Copy-of-Test-Works-sheet-JanFin.zip
 

Direct link to your file
https://filedb.experts-exchange.com/incoming/ee-stuff/4292-Book22.zip 
 
What i require from a develop, is to extract information from the pivot table, and post that information into a different worksheet, the information that i require from the pivot table to be extracted - exact match ......

the sub-total for each Portfolio ID.........that matched and placed in a second work sheet. for example....

Pivote Table is saying:

ID           Name                     total
1            Barclays1               1000
              Barclays2               1000
Total                                    2000

extract the 2000 (sample figure) and post this into a new work sheet that has combined portfolio id similar to col F in the workbook.....so the above would be posted into col f (as a example - against barclays 1+2 as 2000).

But in the new work sheet the macro asks the user which colum and row to add this extarcted information to.....

any question just feel free to ask.....

thanks.....

0
keilah
Asked:
keilah
1 Solution
 
keilahAuthor Commented:
Hi

Last point ignore,,,,,the macro ask the user.....bit..

thanks
0
 
Rory ArchibaldCommented:
If you want to extract data from a pivot table, why not just use the GETPIVOTDATA formula?
Regards,
Rory
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now