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:
I would like to have this result in Excel:
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
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:
I would like to have this result in Excel:
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