brennaboy
07-06-2011, 03:22 AM
Hi,
As part of a macro I am putting together for the automation of a task, I need to tell the macro to drill into the cell of a pivot table and then copy the data to another tab/spreadsheet.
The cell reference could potentially change from one day to the next, so I was going to use the Index function to try and avoid this.
The cell I wish to drill into is at the intersection of "NOTE" and "Grand Total". Below is the function I will use.
However - I am not sure how to put this into the macro code to tell the macro to drill into this cell - can anyone help?
=INDEX(B$11:M$285,MATCH("NOTE",$D$11:$D$285,0),MATCH("Grand Total",$B$11:$M$11,0))
Many thanks,
B.
As part of a macro I am putting together for the automation of a task, I need to tell the macro to drill into the cell of a pivot table and then copy the data to another tab/spreadsheet.
The cell reference could potentially change from one day to the next, so I was going to use the Index function to try and avoid this.
The cell I wish to drill into is at the intersection of "NOTE" and "Grand Total". Below is the function I will use.
However - I am not sure how to put this into the macro code to tell the macro to drill into this cell - can anyone help?
=INDEX(B$11:M$285,MATCH("NOTE",$D$11:$D$285,0),MATCH("Grand Total",$B$11:$M$11,0))
Many thanks,
B.