Limiting entries depending on entries in prior cell
Posted by Ailene Valdez on September 27, 2001 9:50 AM
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?
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. If he chooses 'veggies' from the list in cell A3, then only the list of veggies will appear in cell B3, no fruits. (this is not my real data, of course :-))
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?