Double Dropdown list

Hello !

I am new on this forum but i am using excel for a long time, i love playing with it.

I got a main table with multiple data in one sheet that the user needs to input and i got another sheet with special data that it is already in the program.

i want to do in sheet #1 a dropdown that has almost 25 items from sheet #2 from cells a2:a26 - that's easy
my problem, is that besides that dropdown i want to make another one what will have the info in the row that was selected before.

for example, if i select in the dropdown list the number 5, then on the next dropdown list i will get all the records from b6:t6

I hope you can understand me.

thanks !

Here is one way to do what I think that you want.

If you upload a worksheet with what you are starting with and what you expect (use dummy data if you have to) would be a great asset in helping you.

You need to create dependent lists for each selection possible in your first drop-down list that will return what you are looking for from that drop-down list.

Eg: If you have 1, 2 and 3 in the first drop-down list then you need a list corresponding to each of 1, 2 and 3.

Here is a very simple example of a "cascading" drop-down list....one list leads to another.

I would have to see what you have as data before saying that I definitely could or could not help. You mention road junctions and products so I really don't know what you are dealing with.

If you want to post some representative data, I will give it a try.

Oh boy, was I surprised when I opened your workbook. Right to left and tab names that I couldn't read. No matter, I got used to what I was seeing and did some work.

I took the data that you had for the road junctions and transposed the rows and turned the data into individual tables. This is one way to have dynamically sized drop down lists. The numbers that you had for the road identification had to be modified because the numbers themselves could not be used as names for the ranges that are required for the junctions. So, I added Road # to each of the ID numbers and then used a VLOOKUP table to access the names with spaces and get the same names without spaces. The rest should be self explanatory.

To add junctions to each road, click in the last cell of the table for that road and hit TAB. This will add a row to the table and when you fill the new cell with data, that data will be present in the drop down list for the junction.

When you enter a new road, click in the last cell of the road table and hit TAB. A new row is ready for data. Enter the road name in the same manner as the other roads then in the column to the left enter the name of the table that has the junctions for that road. You can get the exact name by going to the Name Manager and select the table for the new junctions and click on edit. Copy the name that is presented and then paste it into the cell beside the road name.