Hi!
I have a worksheet that lists all of the individual counties in m
state. One cell down and one cell to the right, there is a list of al
the municipalities found in that county. The number of municipalites i
the cell varies and they are separated by commas. For example:

Jameson County
Addison, Ellis, Georgetown, Poplarville
Williams County
Blenk, Crissely, Pohtawah, Stanton
Vaughnton

I would like to be able to create a new worksheet that lists all of th
municipalities in alphabetical order, and then in the adjacent cell
lists the corresponding county so that someone could look up the cit
or town name and see what county it is located in.

I would prefer to do this using a macro because I will need to repea
the steps to update the list in the future. Does anyone have an
suggestions on how I can do this? I appreciate any and all help

--
kmb
-----------------------------------------------------------------------
kmb1's Profile: http://www.excelforum.com/member.php...fo&userid=1573
View this thread: http://www.excelforum.com/showthread.php?threadid=27249