vba pivot table

Hello, I have written some VBA code to generate a Pivot Table from multiple worksheets. Everything looks pretty good to me, but I am struggling trying to change the "(All)" dropdown list box entry at the top of the Pivot Table to something a little more descriptive. I am not sure I can do this...

Greetings, I'm trying to filter between two dates in Excel Pivot Tables using VBA. I need the script to recognize the start date as a date entered by the user in a named cell, and the end date as current date. I've tried several scripts for accomplishing this, but all have failed thus far...

Hi I have spent days attempting to produce some VBA code which tidies up a Pivot Table. I want to remove (hide) columns from the Pivot Table where a particular columns Grand total is zero. So only show me the columns (these are periods) where there is a total. My code is as below; It's the...

Hi I have a worksheet containing code that I have used succesfully many times in the past to produce a fortnightly report (raw data is normally around 10,000 to 15,000 rows). I'm now trying to produce a report for all of last year and have over 279,000 rows of raw data. This initally caused...

Hi I have a data set that contains training data showing who has done a certain course and who hasn't. For those people who haven't completed the course a 'days overdue' value is also shown. I need to create a pivot table to summarise just those who haven't completed the course and who are more...

Hi, I have the following which is designed to export sheets from a workbook along with raw data (hardcoded data) and save them.. What I would like is to change the pivot source in each of the newly exported sheets... Ideally it would change the source prior to saving.. I would like the new...

Hi, I would like to change the source data of my pivot table, from one location to another. The new data is in a different location. appreciate any guidance Thank you

hi, I would like to change a filter within a pivot table using a vba / macro. The filter is called "FPC", and I would like to select "Flat fee" only using the macro / vba. When opened, by default, the pivot will show an option called "activity". I would like deselect this and select "Flat...

Hi, I've recorded a macro to "collapse" a pivot table in a workbook. " Range("B23").Select ActiveSheet.PivotTables("PivotTable6").PivotFields("Account no. & name Concat") _ .ShowDetail = False Range("B22").Select ActiveSheet.PivotTables("PivotTable6").PivotFields("Name").ShowDetail = False"...

Hello, I'm wondering if there is a way to change the report filter in a pivot table to reference a cell in a worksheet. I recorded a macro and made slight alterations to get the code below. Sub ptDate() Dim pt As PivotTable Set pt = Sheets("DrilledDown").PivotTables("PivotTable1")...

Apologies if this has been answered, I'm struggling to know what to search for as I don't know what I'm doing is "called". I have two pivots tables of the same data, just displayed differently for reporting purposes, i.e. one has a timeline running vertically, the other horizontally. They are...

I am trying to update multiple pivot table fields based on values given in a reference tab. The pivot tables I am using are linked to an OLAP query and I can not seem to find a way to get the data to pull from cells in another tab. Do you know how I can update the cells in the reference tab...

Hi All, I'm trying to get my pivot table to respond to a VBA command to filter based on a xlValueIsNotBetween filter type. But I keep getting a Run-time Error '1004': Application-defined or object-defined error Here is the code I'm using. Can anyone give me pointers on why this isn't...

Following is a sub procedure that proudces the desired pivot table just fine if I step through its execution using "F8", if I use "F5" it shows none of the detail. What's really odd is that the detail is there... I look at the filter carot and the fields are populated but they just don't...