Group Years, how to do it?
 

Hi.
on a pivot table I have a field button "OpenDate"on the Category
field section.
Selecting the field button "OpenDate" and clicking the right button I
select "Group and Show details" and then "Group". At this point I group
by "Years".
Is it possible to describe all these steps through Visual basic code?

many thanks to everybody

regards
Scardy


--
scardy
------------------------------------------------------------------------
scardy's Profile: http://www.excelforum.com/member.php...o&userid=33589
View this thread: http://www.excelforum.com/showthread...hreadid=539849

Group Years, how to do it?
 

Did you try recording a new macro while running these steps manually?

HTH
--
AP

"scardy" a écrit dans
le message de news: ...

Hi.
on a pivot table I have a field button "OpenDate"on the Category
field section.
Selecting the field button "OpenDate" and clicking the right button I
select "Group and Show details" and then "Group". At this point I group
by "Years".
Is it possible to describe all these steps through Visual basic code?

many thanks to everybody

regards
Scardy


--
scardy
------------------------------------------------------------------------
scardy's Profile:
http://www.excelforum.com/member.php...o&userid=33589
View this thread: http://www.excelforum.com/showthread...hreadid=539849

Group Years, how to do it?
 

Sure!! I tried recording a new macro while running these steps manually
but Excel doesn't record anything!

Is there an alternative way?

Thanks


--
scardy
------------------------------------------------------------------------
scardy's Profile: http://www.excelforum.com/member.php...o&userid=33589
View this thread: http://www.excelforum.com/showthread...hreadid=539849