vba pivot tables

What is the proper code if the title of your columns change? I am working on a manufacturing capacity outlook file that changes weekly. I need to have my column names in my pivot table change to the upcoming weeks. So instead of: ActiveSheet.PivotTables(“PivotTable5”).AddDataField...

Hope no one minds, I recreated this post with a better title, since I was getting no responses. I need to quickly change which field is listed in the Values area of a pivot table. My current method is to drag the field out of the values area, drag the new field into the values area, right...

Hi I have the below code to create a pivot table and have set the pivot table as the variable, PT: Dim WB As Workbook Dim WS As Worksheet Dim WSsb As Worksheet Dim FinalRow As Long Dim FinalCol As Integer Dim PRange As Range Dim PTCache As PivotCache Dim PT As PivotTable Dim PF As PivotField...

Hi- I keep getting the error "for without next" on this code: The code essentially exports a number of sheets from a workbook along with the raw (hardcoded data and saves. What I'm trying to do is change the pivot source of each pivot within the sheet. I think I'm not too far away from...

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

I am building a workbook for workers to use, to easily cut/paste a report into, and auto generate the work that has a due date of <!--= today, (macro to sort data, and put into new sheet). I built a pivot table macro, for them to use (work presents easier for task work), but I am not sure where...

Hi, My Excel sheets need to have a number of conditional drop down lists. To do this I currently use a fairly lengthy process of =INDIRECT formulas with Data Validation. I want to start using PivotTables more but I wish that each filed within a PivotTable was a named range that would update...

Hey, I'm working on a bunch of pivots using VBA. I need to isolate "Bermuda" in a list of countries and am looking for an easier way to isolate. The list is going to get a lot longer and removing fields individually definitely can't be a solution. Also with Visible=False process, after a bunch...

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

Anyone seen this? Run-Time Error 1004? I want to name the pivot tables so they are consistant and macro errors out. How would I fix? Code: ' Turn off screen updating so the macro will run quicker Application.ScreenUpdating = False ' Turn off auto re-calculation...