In the worksheet,there are two dropdowns as Wheeler Type, Vehicle in cells A1,B1 respectively. There are different types of Vehicles information which are stored in database. lets say 3 Wheeler--Auto, Rikshaw, Moped....4Wheelers--Car, Van, Lorry..
In work sheet you have values in Wheeler type dropdown are 3,4..If i am selecting wheeler type as 3, it should populate the 3 wheeler vehicles Auto,Rikshaw,Moped from the database dynamically to the Vehicle dropdown (B1).Please suggest us the solution to implement the above scenario.
Thanks in advance.
Lakshmi
Bookmarks