Hello

I am looking for an exampel how to search and group same entries in
EXCEL with VBA.
I have the follwoing scenario: unordered categorized data

category data
AAA 33.33
BBB 123.4
CCC 222.22
AAA 19.19
AAA 22.23
CCC 11.11
....

goal,target, entries with same category grouped (normally by using menu
in Excel "Data Group and Outline"

+ AAA 33.33
| AAA 19.19
| AAA 22.23
+ BBB 123.4
+ CCC 222.22
| CCC 11.11

would be great if someone can point me into the right direction.
many thanks

Mark Egloff

the right direction...?
begin by "sorting" on Column
category, ascending.


"joes" wrote in message
oups.com...
Hello

I am looking for an exampel how to search and group same entries in
EXCEL with VBA.
I have the follwoing scenario: unordered categorized data

category data
AAA 33.33
BBB 123.4
CCC 222.22
AAA 19.19
AAA 22.23
CCC 11.11
...

goal,target, entries with same category grouped (normally by using menu
in Excel "Data Group and Outline"

+ AAA 33.33
| AAA 19.19
| AAA 22.23
+ BBB 123.4
+ CCC 222.22
| CCC 11.11

would be great if someone can point me into the right direction.
many thanks

Mark Egloff

thanks but I am not a VBA expert. So if you can give me some example
code snippets would be a starting point
i.e. how do I sort a range? How do I dedect/select same entries? How do
I group them?

thanks
Mark