PDA

View Full Version : Copy data from Pivot table(except headings) to a new tab using VBA



viksar
07-28-2018, 11:14 AM
Hi,

I am fairly new to the world of VBA, I am trying to automate a process for which I am required to copy the Pivot data (Except headings) to another tab and repeat the same process three times. but unsure how to go about it.

Really appreciate pointers on this from the experts

Regards
Vikas

Paul_Hossler
07-29-2018, 07:19 AM
Welcome to the forum -- take a minute to read the FAQ

Q1 - all headings? Page, Column, Row? Subtotals? Grand Totals?

Q2 - "three times" -- same PT or 3 different? -- 3 different sheets or one sheet but stacked 1-2-3 vertiacally or 1-2-3 side by side?

Use [Go Advanced] at lower right and the paper clip to attach a small example with the PT and where you like it/them to end up