Mapping Question

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
 
T

Tom Ogilvy

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

T De Villiers

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top