Question Export filtered pivot table into Excel

Tep

Registered User.
Local time
Today, 09:27
Joined
Oct 6, 2010
Messages
37
Hi,

I would like to export a filtered pivot table (Access 2010) into Excel 2010. I do not want to export all the data in dataview, as is done with the 'Export to Excel'-button. So, for instance, for this pivot table-selection:

attachment.php


I would like to have this result in Excel:

attachment.php


How should I do this? Probably some VBA-coding? I am not very well known with VBA, so some detailed help with this would be very much appreciated! Or maybe there is some other way to solve this?

Thank you,

Tep
 

Attachments

  • Pivot.JPG
    Pivot.JPG
    22.8 KB · Views: 285
  • Excel.JPG
    Excel.JPG
    19.8 KB · Views: 347

Users who are viewing this thread

Back
Top Bottom