I have a spreadsheet that pulls data through from a pivot table into a different format on a frontpage. This absolutely has to be done in this way, there isn't an alternative to this.
I am doing this by using the GETPIVOTDATA() function and this works fine, however I want to also replicate the functionality where you can double click on the pivottable result to show the lines of data that make up the result.
I know I'm going to have to use VBA for this, however I can't find the function that I need to do this..!! can anyone help?
thanks in advance