StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PONeed help using vba to fill in blanks left by excel pivot table when using %difference from previous row
text
Body
copied!<p>So, I'm not very knowledgeable at all yet when it comes to VBA. I have experience with Java, so I understand the concepts of structure behind coding and can read/understand basic-intermediate code. But when it comes to writing it myself, I'm definitely still a 1.5 out of 10 in terms of writing VBA myself. So, any help would be greatly appreciated.</p> <p>So I have the following example pivot table (my actual is about 10 years of data with a few more columns): <img src="https://i.stack.imgur.com/wkStC.png" alt="enter image description here"></p> <p>The red and yellow dots are my problem areas. The columns with blank titles are just %differences from the previous row. However, as you can see, using that leaves blank spaces for the first month of every year (those are the yellow dots). Also, for the year lines, it doesn't calculate the %difference from the previous year (the red dots).</p> <p>So, what I'm needing is (most likely) a PivotTableUpdate or PivotTableChangeSync (I still don't understand the difference actually by the way) to fill in data in those cells with the red and yellow dots. Any thoughts?</p> <p>Edit: As requested, here's the data powering the pivot table:</p> <p><img src="https://i.stack.imgur.com/1jtW7.png" alt="enter image description here"></p> <p>For formatting purposes I moved the bottom half of the set up and to the right to fit it all into one picture.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload