View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jeff.white@amcore.com is offline
external usenet poster
 
Posts: 29
Default VBA Code with Pivot tables

Need help/suggestions on my little problem. I have a basic pivot
table that list a job code number, say 500 in the list along with
their count as tallied via the piv. In column H, outside the piv, I
have a list of 'hot' job codes, there are are about 60 of these. What
I would like to do is have VBA only show, 'TRUE' of those items listed
in column H. And those that don't match to be set to FALSE.

Any ideas out there?

Thanks...!