Excel dependent list

Posted by papalazarou PM | on Mon, 25/02/2013 - 12:06 423 7 comments | report

I have a data list of car makes and models in two columns. I want to create a dependent drop down list but it seems as though you need to store the data horizontally in excel rather than vertically according to my research. I have the make list as a validation list but only want to see the models for the particular make selected.

Does anyone have a workaround or an easier way of doing it? The data I have has some 55,000 records so I don't think any manual tinkering!

Thanks in advance

Comments

There are 7 comments. Login or register to view them.

Easy in Access

neileg | Mon, 25/02/2013 - 12:39

This may help

ShirleyM | Mon, 25/02/2013 - 12:44

Thanks

papalazarou | Mon, 25/02/2013 - 13:22

It's not too difficult

paulwakefield1 | Mon, 25/02/2013 - 14:33

Thanks Paul

papalazarou | Mon, 25/02/2013 - 19:31

Did you name

paulwakefield1 | Mon, 25/02/2013 - 20:35

Access free runtime

neileg | Tue, 26/02/2013 - 13:04