Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table - eliminate rows out of the table
I have pivot table that already generated by macro.
And now get problem & need to solve. Actually I have to hide our inter-company code that €˜may or €˜may not appear under my pivot table above. We have all together Nine inter-company code but may not appear all the time for each running of pivot table. I try to hard code all these inter-co code under my VB, but got error if in case no such inter-co code appear that time. How I can solve this by searching the customer code to check whether they are equal to my inter-company code & then to hide if it is true. my pivot table structure (simpify) Customer code Customer €¦ Sum of Total ---------------------- -------------- ------------------- Also, here my coding by €˜recording function in VB, for hidden cust_code=blank ActiveSheet.PivotTables("PivotTable1").PivotSelect "Cust_code['(blank)']", _ xlDataAndLabel, True Selection.Delete -- aw |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows to columns in a table or pivot table | Excel Discussion (Misc queries) | |||
Code for a Macro that allows a Pivot table to be repeatedly run (fora dynamic rows in a table, but static field names) | Excel Programming | |||
How to eliminate xero values from pivot table and list top 10 only | Excel Worksheet Functions | |||
Eliminate Duplicates in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table- how do I eliminate duplicates in count of name | Excel Discussion (Misc queries) |