If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Replacing list title with list components - urgent!
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! |
#2
|
|||
|
|||
Replacing list title with list components - urgent!
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" wrote: 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! |
#3
|
|||
|
|||
Replacing list title with list components - urgent!
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!!! "AKphidelt" wrote: 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" wrote: 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! |
Thread Tools | |
Display Modes | |
|
|