pivottable vba

  1. P

    Multiple Pivot Table using same cache

    Hi Guys! I'm working on automating data analysis & creation of pivots and charts for which I have Raw Data (441379 Rows, 40 columns). 1) Raw Data keeps changing monthly, so I need a dynamic range. 2) I have to create around 20 Pivot Tables with the same data. 3) As of now I'm defining range...
    • predzer
    • Thread
    • dynamic cell reference pivot automation pivot cache pivot source data pivottable vba
    • Replies: 4
    • Forum: Excel Questions
  2. M

    Extract PivotTable row items in XL03 with VBA

    Hi everyone. First post to the forum, hoping someone can help me with this issue. I have searched the web for hours and also this forum and can't seem to locate the solution but apologies if I've overlooked it somewhere. I accept that it is probably a relatively basic question but I am fairly...
  3. T

    How to control Excel PIVOT tables from a cell(s) value with VBA

    I am creating a dashboard and need to be able to update multiple pivotcharts using a date range that comes from daily dates but is then grouped by month so that I can choose the month and year from a cells that are set up as data validation lists in two seperate cells and have the pivot table...
  4. A

    Link Pivot-Table Filter to Another Cell (Excel 2010)

    Hi, I have an excel model that contains several pivot tables across several worksheets. On the first worksheet of my workbook (called "Summary"), I have a drop down list where the user can select a Text value from several choices. The pivot tables that I've developed in the other worksheets...
  5. L

    VBA - how to use a cell value to filter a PivotTable with a macro

    Hello MrExcel, I made a macro to perform certain filtering actions on a PivotTable, but now I want to use a cell value to make the macro filter on a specific month, so that I don't have to adapt the macro each month. I thought this would be very simple, but I've tried several ways and I got...
  6. A

    Insert header in pivottitles

    Hi I am making a quite large macro to create a pivot table where the user selects the items to sort and make a sum of these: Sub OutputPrUnit() ' ' ' Dim Pt As PivotTable Dim Sortering As String Dim Forstevalg As String Dim Andetvalg As String 'Change to the sheet with data Sheets("Data...
  7. B

    VBA To Change PIVOT Filter without Errors

    Scenario: I have two PivotTabled in one Excel 2007 worksheet; it is required the PivotTables are side-by-side (horizontally next to each other). The left-most PIVOT has a column that holds months; I use the date filter on this column to only show "This Month" or "Last Month" data. As a result...

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