View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sajith Sajith is offline
external usenet poster
 
Posts: 3
Default Pivot table doubt

hi

I have one doubt. I have Month & week date as asingle
dimension. Week date is the child of Month.

using a macro can i unselect the all the weekdate whose
year is 2003 ?

below is the current set up

MONTH WEEKDATE AMT
JUNE 01/06/2003 23
06/06/2004 56
11/06/2003 91
11/06/2004 78
JULY 01/07/2003 23
06/07/2004 34
11/07/2003 54
11/07/2004 86

I want to change like the below...after the macro runs

JUNE 06/06/2004 56
11/06/2004 78
JULY 06/07/2004 34
11/07/2004 86

Thanks in advance for any help regarding this..

Regards