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
Direct link to your file
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
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.....