A
aw
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
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