xlrowfield

  1. S

    VBA function fail w/Pivot tables

    The question I have is why this code simply toggles between showing and hiding the Sales Date pivot field. It’s only supposed to hide the Sales Date pivot field when the cell M11’s value is “Weeks” but it seems like it’s ignoring this second condition of the if statement. M11 is a pivot row...
  2. J

    trying to create a dynamic pivot table

    Hey guys, Ive basically recorded this macro and want to make it dynamic to sort through lots of data. Basically I want to filter the data on one tab and limit it to one voucher and that voucher should have only one signedamount. Then I want to copy and paste that data onto a new tab that has...
  3. N

    Shorten Pivot Table VBA.

    Hi, Can someone please help shorten this code. Thank you. Sheets("SMMRY - WO BY DAYS IN ROLE").Select Set pvt = ActiveSheet.PivotTables("PivotTable1") pvt.ColumnGrand = False pvt.RowGrand = False pvt.RowAxisLayout xlTabularRow pvt.ClearTable 'FILTERS 'FALSE...
  4. E

    Pivot Table Macro, please help!

    Hello, I am seeking out the help of someone here. I am utilizing the code attached to create a pivot table. All was working great, but now a week later I cannot get it to work at all. I constantly get Run-time error '1004' I know its because a portion of my code is not being executed and...
  5. J

    VBA 2nd Pivot table creation error

    Hello, I have the following code that works to create the first pivot table but fails on the second pivot table at the line: 'Create Pivot table from Pivot Cache Set pvt = pvtCache.CreatePivotTable( _ TableDestination:=StartPvt, _ TableName:="PivotTable2") What do I need to change...
  6. J

    VBA Pivot Table: Error If cannot find - How to ignore

    Hello, have the following code, and when it cannot find #N/A in the pivotfield it returns 1004 error code, is there anyway I can adapt the code to ignore it if this is the case? Many thanks. Sub Pivot_Table() Dim sht As Worksheet Dim pvtCache As PivotCache Dim pvt As PivotTable Dim StartPvt...
  7. J

    Pivot Table Question

    Now having created and formatted the pivot table below, I need to filter column "Mileage", to show only "#N/A" what would be the code for that please? Many thanks. Sub Pivot_Fields() Dim pvt As PivotTable Dim pf As PivotField Dim pi As PivotItem Set pvt =...
  8. P

    Trying to Find Work-Around When Removing Pivot Table Data and There's No Data Left???

    Hello, I use code to gather data, create pivot tables, and assess the data. I exclude certain "Account" ("Account" is the column header) data criteria on certain pivot tables. For example, if any pivot table row field under "Account" contains "XXX", I remove XXX from the pivot table by filtering...

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