Merging two lists together using VBA program

[excelslizzard]

Hi,

I have a worksheet with two separate lists. I need to merge the two lists to form one list so it contains the states in a given region together (i.e. western states together etc.). How can I write a VBA program to do that.

Attached is the workbook:
States.xlsx

Thank You.

[jindon]

try

Please Login or Register  to view this content.

StatesWithCode.xlsm

[excelslizzard]

Perfect. Thank You so much.