Wise Owl Answers How do I group a pivot table by a numeric field using VBA?

By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:

This video shows you how to apply grouping to a numeric row field in an Excel pivot table. You'll learn how to use the Group method, how to control the size of the buckets or bins and how to set the starting point of the groups. You'll also see several ways to refer to the range you need to apply the grouping to.

Chapters
00:00 The Question
00:24 Creating a Basic Pivot Table
01:12 Basic Grouping with a Numeric Field
02:28 Changing the Bucket or Bin Size
03:06 Changing the Start Value of the Groups
03:57 Referring to the Label Range
06:27 Changing the Pivot Table Position
07:17 Referring to the Row Range

[nadermounir]

Thank u Amdrew for this video. I am a new VBA learner and try not to miss any of your videos

[jmathew]

🙏 Thank you Andrew sir! Today is another instance when one of your lectures saved my day :)

I had used up lots of my time browsing answers for a method to change pivot table column headings (subtotal of grouped columns, in this case), all using VBA. I got the idea after watching this lecture. Using Range and ColumnRange properties, I was able to loop through all the headings, get their addresses and cell values and modify where needed. There may be other direct methods available, but for now I found an easy solution suitable to achieve the objective.

As always, every possible detail brought up and explained in the best possible manner. Sincere gratitude 🙏

[uriellopez]

thanks Andrew...great video .I always learn something new watching your videos.

[wayneedmondson]

Always interesting and informative! Thanks Andrew. Thumbs up!!

[vetrivelr]

Your the best as far as i known. I am positioned as a vba developer now due to your videos. I have suggested many people your videos. Had an idea till today as per your voice, you might be a Chinese. But its glad to finally see your face. Really happy. If possible please start python automation related videos. God bless you..!

[frikduplessis]

Thank you Andrew for a brilliant tutorial as always 👌I did something similar in the week grouping AVG age vs and I was thinking It would be cool doing it this way....

[scotolivera]

thanks for this excellent tutorial, it would be very helpful you cover xml parts in vba like saving and retrieving data …

[tejamarneni]

Hi Andrew. Thank you so much for the video.The entire VBA series from you is amazing. One quick question, do you watch football or cricket if you are free? My friend recently introduced me to English Premier League and I got hooked.

[RAVISHARMA-hniv]

your every video adding new skills in my life. thank you so much... as a fan, can i know your age? ;-)

[iliesmeziani]

Thank you very much sir for your video it’s very interesting
Please if I want to filter only two elements of the certificate column how I can change this code
Columnfields:="certificate"
Salutation

[TheSardOz]

Hi Andrew, I have applied conditional formatting to a pivot table so when I select a cell in the table the full table row will highlight, but when I refresh only the values field loose the formatting…
Do you know how to stop this with VBA?

[romanemul]

What are you collecting ? Are there movies, games or music behind your back ?

[분홍감자-ff]

Hellow!
range("??").Group By:=, Start:=


How do I apply By value auto?
I want to be applied to Excel.
Not manual.

For example
Range("A5").Group By:=Auto, Start:=100, End:=100