Using a Macro Export to excel

[#1]

Good Morning All,

Using a macro I can export the QV pivot table to excel file its good but in my requirement is it should be as a pivot table as in Excel.

I have attached two outputs, the Test excel file is using a macro its exported and Test 1 is my orginal requirement.

Using a macro is it possbile, can any one help me on this...

Regards

Chriss

[lironbaram]

hei

the solution for your problem is to export the data you want but in strait table format

to specific file

then run a macro in the excel file that creates pivot table

i'll try the post an exmple later

[#3]

hi,

thanks for your reply, thanks in advance for your example.

Regards

Chriss

[#4]

Hi liron baram,

I am still waiting for your sample file, can you please attach me.

Regards

Chriss