As part of a wider project i need to drill into pivot table data and create the line item detail of the data required on a separate tab.
I could just double click the table, but the table will be constantly updating and I want to automate this on each update.
This will come later, and not part of this request, hence why only £5 offfered.
What I would like guidance and code on is the following:
- Code that automatically drills into the pivot table, can assign to a macro button for now (just a test)
- Code that renames the sheet created based on a value in sheet1(Range A1:A1)
My thoughts are that this should be simple and require only two or three lines .
If this is not the case let me know and I will reconsider my approach.