Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Doubt about pivot table | Excel Discussion (Misc queries) | |||
doubt | Excel Worksheet Functions | |||
I have a doubt! | Excel Discussion (Misc queries) | |||
some doubt | Excel Worksheet Functions |