Hello,
I'm trying to write a macro that will hide pivot table rows if a certain condition is met. What I'm trying to do is the following:
- If the Row Label, for instance Google, contains SF and SV under it, then I would like it hidden.
- If the Row Label, for instance Apple, only contains SV or SF, but not both, then display.
Google 112 10969763SF 4 862166
SV 108 10107597
Apple 71 6415615
SV 71 6415615
Could someone please assist???
Thanks!!!
I'm trying to write a macro that will hide pivot table rows if a certain condition is met. What I'm trying to do is the following:
- If the Row Label, for instance Google, contains SF and SV under it, then I would like it hidden.
- If the Row Label, for instance Apple, only contains SV or SF, but not both, then display.
Google 112 10969763SF 4 862166
SV 108 10107597
Apple 71 6415615
SV 71 6415615
Could someone please assist???
Thanks!!!