T
T De Villiers
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
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