Hi ,I need a macro which takes the data below, takes the mapping between

entries in the 'WW' column and 'XX' column and produces a list for each
'YY' entry (as shown below). I need this to be dynamic as things will
change:
e.g. YY will become "a,b,c,d,e,f....."

Many Thanks

WW XX YY
1 a a
2 a b
3 b c
4 b d
5 c
6 c
7 c
8 d

and puts it in the following format:

a
1
2


b
3
4

c
5
6
7


d
8


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=530469