Excel dependent list

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 |

This may help

ShirleyM |
ShirleyM's picture

Thanks

papalazarou |
papalazarou's picture

It's not too difficult

paulwakefield1 |

Thanks Paul

papalazarou |
papalazarou's picture

Did you name

paulwakefield1 |

Access free runtime

neileg |