Hi,

I need to copy a Pivot Table into an existing table. I have just about got everything working however, the copied range of the pivot table needs to be pasted into the Column headers of my table. That is "shifted by 1 row up". Does anyone perhaps have an eloquent way of doing this?

Q03 Copy pivot into table with VBA.xlsm

Capture.PNG

Thanks in advance,
Michelle