View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lpolliard lpolliard is offline
external usenet poster
 
Posts: 1
Default Auto Hide Pivot Table Items

Hi ya all...

I want to automatically hide line items in a pivot table base on a
comparision. Lets start with a simple pivot table of jobs and sales$.
Can someone help me with a macro which will select all jobs whose sales
are below a certain amount and hide these jobs automatically?

Thanks much...you guys rock!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/