Choose from list depending on entry in the prior cell
Posted by Ailene on September 26, 2001 10:38 PM
I have a data validation list in column A. How do I limit the list/choices for column B that depends on the user's entry in column A?
FOOD CATEGORY KIND
If user chooses 'fruits' from list in cell A2, then the only choices he has available for cell B2 are kinds of fruits, no vegetables appear on the list.
Am new to this board, but this site is now bookmarked! I've been using spreadsheets for a while, but haven't really used macros or any VBA coding, so please let me know if my dilemma can be solved just with the knowledge I have now, or will it require more studying on my part?