Copy-Paste a Pivot Table in the same place where it begins & Retain the format if possible

[e4excel]

Dear Forum,

I am creating a Pivot Table from the code which I got on the net and it works fantastically well..But I want to create Multiple Pivot Tables and therefore I need to Copy-Paste the Pivot Table and Copy it exactly in the same place where it was created, however I am unable to do so. I would appreciate if we could also Copy-Pate it as values along with the formatting however if that's not possible its still okay.

I found some code on the net which I am trying to tweak in my file in vain. as this code creates a copy in a newly created sheet whereas my requirement is to have this value in the same sheet in the same cells as the Pivot Table..
I have a series of Pivot Tables to be created one below the other.

Please Login or Register  to view this content.

I need to get a copy and also delete the first two rows on top.

Warm Regards
e4excel

[e4excel]

I tried the below code too...Calling the below Sub_routine in my Sub-Routine, however it still does not work..

Please Login or Register  to view this content.

[e4excel]

Can anyone please help me