VBA add a pivot Table, and copy the content.

[jamiguel77]

hi all normally i do:

select 2 columns(ItemName, ItemQty), select 2 columns with data,

go to insert Pivot Table, and select new sheet, and configure my Pivot Table: ItemName and Sum(ItemQty).

give me unique name, with sum, and a Grand Total.

Right?

How to do this with VBA?

Thanks

 

[jamiguel77]

and after this, copy entire table to another new sheet, and delete the pivot table sheet

thanks