Fill Drop Down Based On Choice From Another

  • Hi


    I use excel 2003 and am hopeless with excel would appriciate some help


    What I want to do is
    lets say in the drop down menu I have options Food, sports, Movies


    now if I select Sports
    then it should give me a sub caterory options like baseball, hockey, football and not the options for food & movies as well - so as to make the choices lesser and more user friendly


    How do I create that - is it too tough - I am a novice in excel


    Can you upload an example sheet with tips on how you did it.


    I have uploaded an example its not much but hope it helps you to understand what I need.


    Thanks in advance

  • Re: Fill Drop Down Based On Choice From Another


    Thanks a lot jamierodgers & AAE


    That was fantastic - I hope I have enough brain power to modify it to my requirment


    AAE as a matter of fact I did see the link to Dependant page - but based on my search skills I saw it only after the question was put up.


    Thanks a buncg guys

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!