Thread: Automating grouping of Excel pivot field
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming,microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default Automating grouping of Excel pivot field
How could you automate this, if there's no relationship among the numbers?

wrote:
I am trying to group a list of numbers (hundreds of them). They are a
set of ID's that have no relationship to each others.

I can do this manually by selecting the desired numbers and then right
click and use the - Group and Show Detail - Group function.


On Mar 5, 4:14 pm, Debra Dalgleish wrote:

What are you trying to group -- numbers, dates, text fields?
If you provide more details, someone may be able to help.

wrote:

We can group the values in a field in an Excel pivot. Is there away to
automate this process via VBA?

I want to group a lot of values.

Thank you in advance.

--
Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote