Grouping a pivot table by variable groups

N

njones3

New Member
Joined
Apr 25, 2019
Messages
12
Office Version
  1. 365
Platform
  1. Windows
Hi,

I am trying to come up with VBA code for a pivot table where by the row groupings change depending on the numbers in specific cells.

For more context, I have a 70,000 row list of consumption amounts which i would like to be able to split depending on the way i have split some tables in a different sheet eg 0 - 5000, 5000 - 10000 etc.

Any help would be massively appreciated!
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Sort by date Sort by votes
More explanation may be needed to be able to advise.

Maybe an extra column in the source data can have a VLOOKUP type function to know the groupings from the different sheet's data?
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question
Conditional formatting on pivot table headers
Replies
0
Views
127
D_SQUARED
D
B
  • Solved
Pivot Table won't Group Dates from growing Table
2
Replies
13
Views
719
BrerRabbit
B
D
  • Question
I Can Only Group Dates by Selecting all Cells, not Single ones. Dialogue Box Won't Pop Up
Replies
1
Views
576
arthurbr
arthurbr
Z
  • Question
Excel table To split or not to split??
Replies
5
Views
288
Fluff
Fluff
M
  • Question
Creating a model - Unable to get trend function to run properly
Replies
2
Views
184
Misono
M

Forum statistics

Threads
1,215,022
Messages
6,122,726
Members
449,093
Latest member
Mnur

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top