Is there anyone that can give me some help on some Excel formulas?

Posted on November 25, 2011 | 2 Comments

example: Column A I want to list say McDonalds, Dairy Queen, Burger King, White Castle. And then I want column B to be validated to just a range of cells depending on the criteria entered in Column A. Say you chose McDonalds. So in Column B I only want McDonald’s menu items to come up.

does that make sense? Thanks for any help

This entry was posted in Queen Rearing and tagged , , , , , , , , , , , , , , , , , , , . Bookmark the permalink.

2 Responses to Is there anyone that can give me some help on some Excel formulas?

  1. AQuestionMark | November 25, 2011 at 4:29 am | Reply

    This solution is to use a validation list dropdown, a table and a formula to show the menu items when a fast food store is picked.
    http://www.freewebs.com/swhtam/YA/combo2MenuList.xls
    It contains notes on how it is build,
    Please contact for more info.

    short story—-??—-

    Report Spam/Abuse

  2. VBAXLMan | November 25, 2011 at 5:29 am | Reply

    Yes, it does
    This is called Validation based on Validation

    Use this file, it will help you a lot
    http://file1.net/lesson.asp?id=18

    Also see other Validation lessons and files here

    VBAXLMan

    http://file1.net/search.asp?query=validation&in=All

    Report Spam/Abuse

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>