Export to Excel

[soha1902]

Hi All,

I want to export pivot table to excel sheet with different formatting. QV pivot table is look like below image:

Desired output which I want in excel is look like below image:

I wrote macro to export chart to excel but not able to get the desired formatting.

Thanks.

[amit_saini]

Hi Soha,

Are u talking about date format while exporting.???

Thanks,
AS

[soha1902]

Hi Amit,

When we clicked on Export to Excel button then I want excel sheet as per attached image (available in original post). (Font Size, background color, cell merging etc)

Thanks.

[amit_saini]

Soha ,

I don't think so it is possible .

Thanks,
AS