Export to Excel - Different Sheets in the Same Workbook

[#1]

Hi,

Suppose I have 10 markets in data and 1 pivot table.

I want to export 10 tables to 10 excel sheets with different market selected.

ie. select Market A export to Sheet 1, select group B export to Sheet 2 etc.

I need a macro that can automatically select each market one by one, and export the pivot to each excel sheet.

I've seen the same question on forum but there was no answer. Does anyone know where I can find examples? THANK YOU!!

[rohit214]

Hi Dani

your script very helpful for me but i am not able to get dynamic sheet name  means i want

that each sheet shold have starting name with their dealer name.

Thanx& Regards

rohit

[rohit214]

hi

can you translate that macro in english

Thanx& Regards

rohit

[#4]

hi Gaa,

  I am getting the following error El componente ActiveX no puede crear el objeto: 'Excel.Application' -- do you have any idea why?

Thxs, Cecilia.

[#5]

Please add PE enabled files.