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