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.

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

(E-Mail Removed) 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
Contextures
http://www.contextures.com/tiptech.html

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 <d...@contexturesXSPAM.com> wrote:
> What are you trying to group -- numbers, dates, text fields?
> If you provide more details, someone may be able to help.
>
> xpi...@gmail.com 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

How could you automate this, if there's no relationship among the numbers?

(E-Mail Removed) 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 <d...@contexturesXSPAM.com> wrote:
>
>>What are you trying to group -- numbers, dates, text fields?
>>If you provide more details, someone may be able to help.
>>
>>xpi...@gmail.com 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

If the grouping can be done through VBA then I can have the VBA code
read from a table or list instead
of having to select hundred of different cells manually.

On Mar 5, 5:02 pm, Debra Dalgleish <d...@contexturesXSPAM.com> wrote:
> How could you automate this, if there's no relationship among the numbers?
>
>
>
>
>
> xpi...@gmail.com 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 <d...@contexturesXSPAM.com> wrote:
>
> >>What are you trying to group -- numbers, dates, text fields?
> >>If you provide more details, someone may be able to help.
>
> >>xpi...@gmail.com 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
> Contextureshttp://www.contextures.com/tiptech.html- Hide quoted text -
>
> - Show quoted text -