Hello,

I have a table with 2 columns.


Company Model
BMW 520
BMW 720
AUDI A8
MERC XYZ
AUDI XYZ
MERC Etc
BMW Etc
SUZUKI Etc
MERC Etc
SUZUKI Etc

A company can have multiple models. What i need is.. 2 Drop down boxes.

1. 2 drop down boxes. 1st to select company, second will only show models from that company.
2. Anyway to give auto complete option? for eg. i type H and it shows me Honda and Hyundai in drop down?
3. I should be able to add new models at bottom and it should auto update.

PS: I am ok with using VBA if there is no other option.

Thank you.