Ok so I am not exactly sure where to begin coding this, I am not very
advanced with vb. My task is to take a list, i.e: (I am getting this
list from MySql from an Access Database and dumping it into an empty
sheet-I already have this working)

AA 1 A1
BB 2 A2
CC 3 A3
CC 4 A4
CC 5 A4
CC 6 A5
CC 7 A6
DD 8 A7
DD 9 A7
DD 10 A7
EE 11 A8
EE 12 A9
FF 13 A10
GG 14 A11
GG 14 A12
GG 14 A13

And create an index(a new list) for each unique combination, stripping
all of the repeat values, i.e:

AA 1 A1
------------------------
BB 2 A2
------------------------
CC 3 A3
4 A4
5
6 A5
7 A6
------------------------
DD 8 A7
DD 9
DD 10

This is sort of an example of what I want but not exactly, because
what I need to be able to do in the end is have validation lists,
where you click on one list then the next list changes to the
corresponding cell. I am not too worried about how to do the
validation, I just need to get the lists setup so that I can start
working on that part. The part I have is:(The first list)

AA
BB
CC
DD
EE
FF
GG
HH
etc...

After the first list, it needs to be able to break off into the the
other unique list...
Any help is appreciated, thanks!