Dynamic Export to Excel from object

[#1]

Hello there,

I have a table/pivot chart which has 100+ salesmen names. I want to create a macro that can export the data(chart) for all selected Salesmen from the list box to any Excel as separate sheet.

Regards,

Vidit Desai

[marcus_sommer]

Have a look here:

Loop Charts and Field Values - Excel Export Macro

VB Macro to Loop (User-Defined) Field and Export (User-Defined) Chart to Excel and Name Sheets by Fi...

- Marcus

[tresB]

Check this: VB Macro to Loop Field (Dynamic) and Export Chart (Dynamic) to Excel & Name Sheets by Field Valu...