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.

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 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

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

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 wrote:
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
Contextureshttp://www.contextures.com/tiptech.html- Hide quoted text -

- Show quoted text -