pivot table macro

  1. R

    Pivot table options and macro

    I created a pivot table with the filter from Marketers. However, I would like a table for each marketer. I know under options I can use the "show report filter pages" which creates a TAB for each marketer. Is there a way to apply the same concept to the same tab? The only way I can think to do...
  2. D

    .Orientation = xl rowfield - Unable to set Orientation property error

    I am trying to create the following pivot tables on a single sheet named Pivot. I extract data from another workbook and then run pivot for the exported data. The Highlighted red (below code) line throws 'Unable to set orientation property error'. The Department Level(1) column has varied row...
  3. cgeorge4

    MACRO PROBLEM: How to adjust a recorded pivot table to capture varying rows/Report Filter

    Using Excel 2007 - Windows 7 I need to adjust my recorded PT macro to capture all rows 1) Pivot Table should be on the same sheet as the Data 2) Data is in Column A thru P. 3) Data range has varying number of rows from month-to-month (300 to approx. 5000) 4) Pivot Table should be on column...
    • cgeorge4
    • Thread
    • dynamic range pivot table pivot table macro varying rows vba
    • Replies: 2
    • Forum: Excel Questions
  4. D

    Pivot Table sum not count!

    The following macro creates a pivot table and the data is suppose to aggregate by sum not count but it is NOT COOPERATING! Here is the macro which to my understanding tells the pivot table to do a sum of the data. Can anyone propose a corrected code or another string of code to make it do the...
  5. K

    Adding pivot tables into a macro?

    Hello- So I am trying to add a pivot table into a macro to sort my data. I just recorded the macro while setting up the pivot table I needed but now it has an error almost immediately. I changed a few things around hoping that would do it but nope. The red text is where the error is right now...

Watch MrExcel Video

Stacked & Clustered - 1091 - Learn Excel Podcast

This Week's Hot Topics

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
Top