Macro to export a report to excel based on List Box Values

[#1]

Hello,

I am having pivot table and a list box, I need to export Pivot table for each value in list box to separate Excel files. Thanks

[ecolomer]

Hi,

must build a loop in which you go through the various values ​​in the list and running the excel extraction time.

I've attached an example of extraction Aexcel