need help ms excel expert

[creative_eyes]

asalamu alaikum itdunya members mujhe excel me ye jo screen shot me goal dayre me hi is ko kiya kaheten hien aur isko excel me kistarha se bana te hien
help me thanks

[syar]

salam::

in ko dropdown lists/menu kaha jata ha. Kuch drop down azad hote hain aur kuch aik dosre pa dependent hote hain yane vlookup ki tarah kam karte hain agar aap aik drop down m se kuch select karain tu dosrie drop down k value us par depend hote ha.

Ye Data-->validation k through bante hain. Aur kuch VBA m coding k zarye bhee banae jate hain.

regards