xlrowfield

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

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

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

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

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

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

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

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