Replacing list title with list components - urgent!

[DBenny]

I apologize in advance for my naiveté..

I have a datalist in one worksheet that contains data associated with a list
title. The list is contained in a 2nd worksheet. I'm looking for a way to
replace the list title with all the entries that compile that list.

For example, if cell A2 in the 1st worksheet contains "ALABAMA," all of the
data in that row is applicable to a list of cities in Alabama. The 2nd
worksheet contains a list of cities applicable to each state name. How can I
create an additional row on the first worksheet for each city name and have
the new rows contain the same information that it's corresponding state
contains?

I would just do it manually, but my datalist is over 31,000 entries long,
and the state names/list titles repeat with different data.

Thanks so much for your help!

 

[AKphidelt]

I think I can help you if I better understand your question. Can you explain
it in a little more detail. So when you select Alabama in A2, you want all
the rows below to be data of alabama cities? or what is it that you are doin?

 

[DBenny]

Sorry for not being more clear... I think you have the right idea. For
example, if A2 is Alabama, and A3 is Illinois, I'd like rows to be inserted
between the two entries for each of the different cities in Alabama
referenced on the 2nd worksheet. The information in Row 2 for Alabama would
then also apply to all the cities below it.

In otherwords, on the 1st spreadsheet, I have data that applies to a group
of cities but all of those cities are defined in a grouping titled "Alabama."
Then the 2nd spreadsheet is the key for what cities apply to each grouping
(i.e. A1="Birmingham" A2="Decatur" A3="Montgomery"; B1:3="Alabama"). I just
need the 1st spreadsheet to have an entry for each individual city, rather
than the group/state name.

Hope this helps... thanks so much for helping me out!!!