I have a workbook (attached) that has two entries in column A (apples and pears). Varieties of apples and pears are in column B
If a user selects Apple in column A. I would like the column B drop down list to show all the various types of apples in the
If the user selects Pears in column A, I wouuld like the drop down list in column B to only show the various types of pears.
Can someone help me with this in either VBA or Data validation, or something else.