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