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

will YY exlude any of the values found in WW or do you really want a
reformatting of the data in WW and XX.

Where will WW and XX be located. Where do you want the reformatted list.

--
Regards,
Tom Ogilvy


"T De Villiers" wrote:


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

Sorry Tom, my query is obviously not clear

I just want a re-formatting of data in WW and XX.

The raw data is on one worksheet, I want the re-formatted data on
another.
Any more questions pls let me know.


--
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