Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Divide comma-separated string and look up corresponding category
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide a string words separated by (number) | Excel Discussion (Misc queries) | |||
text string separated by comma | Excel Discussion (Misc queries) | |||
How can I extract the first & last name separated by a comma | Excel Discussion (Misc queries) | |||
Fixing Comma Separated Values (.csv) | Excel Discussion (Misc queries) | |||
Going from column to comma separated list... | Excel Discussion (Misc queries) |