I am trying to get a VBA code which will take data from a pivot table and put this into a new table.
The problem is the cell each week changes due to the data inputted into the Pivot Table. How can I create a VBA code that will pick up the desired cell each time even if this is in a different place.
VBA Code for extracting data form a pivot table into another table.
Hello.
As you can see from an attached simplified example.
I am trying to create a VBA code that will extract certain information from a pivot table and put this into a table on another sheet.
In the simplified example I am trying to get all the Male (M) entries in the pivot table into a table titled 'Male Table' How do I go about doing this...?
I also have a problem as when the pivot table gets updated with more data, the number of Males entries will go up etc, and therefore data will be in different cells compared to the previous week. So I need the coding to pick up all male entries within the pivot table, regardless of their cell reference, and copy the data across into the 'male Table'
Please advise as I have been struggling with this for some time now.
Thanks for your help in advance