automatic pivots

  1. A

    Filter Excel Pivot Table based on Cell Value

    Hi, I am creating a Glossary for a table with a lot of descriptions of certain activities. I want to be able to type in a cell a value and click the comand button to filter automatically instead of in the Pivot filter. I tried with this code but keep getting an error on the highlighted code...
    • aroig07
    • Thread
    • automatic pivots beginner filter pivottable vba
    • Replies: 1
    • Forum: Excel Questions
  2. C

    VBA Pivot Items

    Hello, I'm trying to automatically set the current year and next year in a pivot table using VBA. This is what I have currently Dim CurrentYear as Variant Dim NextYear as Variant CurrentYear = Year(Now()) NextYear = Year (Now())+1 With ActiveSheet.PivotTables("PivotTable1").PivotFields("YR")...
    • csamy987
    • Thread
    • automatic pivots automation pivot items pivot tables vba pivot
    • Replies: 3
    • Forum: Excel Questions

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