pivot table by vba

I have a list of properties in a Pivot table and want to have it so its like A Real Estate website where you choose between certain price points. Slicers dont really work as there are over 25 price points. I have done some research and there doesnt appear to be a kind of timeline for just values...

Hi all, I am setting up a macro to run a few pivot tables that from a the same data source in a single worksheet. I know how to manually make the pivot table a data model which will enable me to do the function of distinct count in the pivot table. But I have not been able to make that work in...

Hi, I am looking for a macro to update the data source automatically. This will also mean that the table range will increase with additional rows, sometime additional columns. Each month we receive 2 source data files which I save to our server for the given month. Both data files are saved...

Hi, I tried creating the pivot table by VBA code but I failed. Can Anyone please help me??? Sub Pivot_Test() Dim Psheet As Worksheet Dim Dsheet As Worksheet Dim Pcache As PivotCache Dim Ptable As PivotTables Dim Prange As Range Dim Lastrow As Long Dim Lastcol As Long On Error Resume Next...

I have been trying to tweak this for a long time, and I'm sure there is an easy fix for this, I just haven't figured it out. My goal is to automatically update the Pivot Table based on the new data in the worksheet with Headings on row 5. Any help would be greatly appreciated. Thank You in...

Hi all. I was wondering if it was possible to alter a Pivot Table based on a Slicer Selection. For instance, I have a pivot table broken out by region. I would like a macro that would add a sub region if the West Region was selected, and City if the North region were selected, but if the...

I would want to have a Drop down list with three Options - class 1, class 2, class 3 Based on the Option selected, the macro should create Pivot table for each class.Data for each of the option is available in the same worksheet (MyData) class 1 needs pivot on column1 and column2 ->...

Hi all, I want to achieve the following: have a pivot table update based on a change in a cell. This cell is being populated based on another cell. I have been trying multiple options for the 'cell controlled pivot filter' over and over. Thought I had it in a test file but when I use it in my...

I just encounter this issue and want to find a solution to auto filter just the most recent date in Pivot Table via VBA. Like I want to set "TIME" column as filter field in Pivot Table. I searched online and modified a little bit to see whether it could work. Here are the codes: Module1: Sub...

Hello I am kind of new in VB and I am trying to control different pivot tables with a combobox, but when I try to do so I receieve the same error that says: "Error 1004: Application-defined or Object-defined Error". This is the code that I am using. Could someone help me to solve this issue? Sub...

Hi All, Long time reader of this forum but first time posting. I don't normally ask for help as i prefare to read as much as i can to understand coding better.... but for the first time in 8 years of this job i'm close to giving up on trying to work this issue out. What i'm trying to do, i...

Hi All, I'm a newbie with VB & macros, i've been recording a macro manually and tried to edit it with bits and pieces that i found on several forums. It does work to a certain extent but i'm hitting several issues. i have a workbook with 3 sheets "NECA ASR Pivot Table", "Install Compliance...