Vbmacro for exporting 2 listbox and one pivot table?

[#1]

hi have

two list boxes

one is country and second one is city

third object pivot table

now if i select one country in list box i want export all the city data into single excel file with each sheet contain each city pivot table data sheet name renamed with city name.

and same for all the countrys

please help me on that if any vb script code please share tahnks

[tresesco]

Have a look here: VB Macro to Loop (User-Defined) Field and Export (User-Defined) Chart to Excel and Name Sheets by Fi...