Hi All,

I am creating macro for pivot table. I have Button in first sheet and data from which pivot table needs to be created in second sheet and in third sheet i want to show the pivot table.

On everyday morning i will clear the previous data from all sheets(including pivot table) and will add the new data to second sheet.

However, i am not getting how this needs to be done. coz the pivotablename is getting change all the time. For e.g. if i recorded macro with PivotTable1 if i run it again it is showing me error.

Can anyone tell how shld i achive this ?

Regards,
Rohit Pundlik