groupings

Morning All, I'm trying to avoid my dozens of pivot tables date groupings being lost in the event of a date being accidentally left blank in the source data. I've been toying around with the PivotTableBeforeAllocateChanges event but have had no joy, it just doesn't seem to work. As a test I...

Hello, Hope someone can help. I have a refreshable sheet named "Report" with data running from A6 down to A150. Months from April 2019 to March 2020 run across the page. This data in column A is in the format AREA1 Worker 1 Worker 2 AREA2 Worker 1 Worker 2 Worker 3 etc and it all finishes...

I have a sheet of about 1000 rows ... So there are 11 rows of Master Order numbers but only 5 different Master Orders. Some Master orders have Slave orders, some do not. If a Master order has a Status of 12, 13 or 14 or a Type of 02 I need to remove that row. The problem Im having is...

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...

Hey, I have grouped amounts and it equates to the subtotal. I would like to sort all of the subtotals will my groupings follow?

Hi. I'm a school timetabler and for irrelevant reasons need to split the day into 20 minute slots. We have two lengths of lessons, 60 minutes and 100 minutes. When I export the timetable from the timetable software to excel I get the class name duplicated in three cells for 60 minute lessons...

Hello, I have a spreadsheet that has many row groupings. There are columns that only need to be seen when any of these row groupings are expanded. I figure this will require VBA code to accomplish. Not in my wheel house. Could someone please help by sharing code that will automatically...

Hi All, How do I incorporate this? If column called Groupings = "Big" and the column "Sub Grouping" does not contain "Tasks" then return "Investment" If column "Groupings" = "GDE" or "Tasks" return "Fail" Everyone else return "Other".

Is there a way you can protect a worksheet and still be able to open and close groupings? thanks for any help Juan

I need a VBA Button that will toggle between "Expand All" and "Callapse All" for the groupings on a given worksheet. Any help would be appreciated. Thanks!!!

Hi everyone, I have an Excel 2007 Spreadsheet which takes a data-set and groups the results into column ranges: <tbody> ID 1-9 10-19 20-29 30-39 40-49 50-59 001 2, 8 13, 16 22, 29 N/A N/A N/A 002 N/A N/A N/A N/A 41, 44, 48 52, 56, 58 003 N/A 11, 12 23, 26 33, 38 N/A N/A 004 1 11 24 34...

I am working with a Classic Pivot Table and have one thing that is troubling me. I have grouped my data and got things displaying however only the first record of each group is populated (displayed) Groupings/Row Labels Data Values Over Here Field1 Field2 Field3 3...

I am working with a Classic Pivot Table and have one thing that is troubling me. I have grouped my data and got things displaying however only the first record of each group is populated (displayed) Groupings/Row Labels Data Values Over Here Field1 Field2 Field3 3...

I am stuck! I am creating a pivot chart based on data that is updated every month. The simple question that I need answered is how I can group a number of variabes in different groups so that I can just click on a tab on the chart and choose the group I am looking for. In this case I have a...

Hi there Pivot Tables Gurus, I have 2 pivot tables on the same worksheet that reference the same database by using a dynamic named range. My 2 pivot tables show values by date, but I want the one PT to be by date, and the other to be by Month, however if i change the one, the other updates to...