MS Excel VBA Pivot table link cell fetch records

[asxastro]

MS Excel VBA Pivot table link cell fetch records


I have a table 'tbl_Final' in MS Access 2007 where the data is used
and cached in a pivot
table found in the 'Data' worksheet in MS Excel 2007.

In this MS Excel 2007 workbook, I have various worksheets reports
which links to the pivot table values
found 'Data' worksheet.

I linked formulae in one of the cells found the worksheet reports,
looks like this:

=GETPIVOTDATA("Amount",Data!$B$4,"Month",
2,"Year","2008","Scenario","Budget")

Lets say the cell value total is: 1000

So, In pivot: 1000
In worksheet report: 1000


If I go to pivot table where this '1000' value is and double click on
this value, MS Excel builds
another worksheet with all the individual transactions that makes up
the '1000' value.

If I then go to the '1000' value found in the worksheet reports; this
link, when double clicked, will NOT
build another worksheet with all the individual transactions that
makes up the '1000' value.

Question: Is it possible using VBA to build some functionality in MS
Excell to allow the '1000' value found
in the worksheet reports, when double clicked, on that cell to build
another worksheet with all the individual
transactions that makes up the '1000' value?

I'm not sure how to write this MS Excel VBA logic if doable.

Any help appreicated

Many thanks in advance.

 

[Doug Robbins - Word MVP]

This newsgroup is for questions in connection with the use of VBA in Word.

For questions about its use in Excel, you should post to the
microsoft.public.excel.programming newsgroup.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com