I am trying to create dynamic drop down lists based on the value of another cell. Essentially, there are 2 columns impacted:
A1 = Item ID
B1 = Type
If I select Apple in the drop down list in B2, I would like the options in A2 to reflect values from a sheet called Apples.
If I select Cars in the drop down list in B2, I would like the options in A2 to reflect values from a sheet called Cars.
I'm thinking that I might need to use VBA for this, but I really would prefer not to, since I don't need VBA for anything else in this workbook.
A1 = Item ID
B1 = Type
If I select Apple in the drop down list in B2, I would like the options in A2 to reflect values from a sheet called Apples.
If I select Cars in the drop down list in B2, I would like the options in A2 to reflect values from a sheet called Cars.
I'm thinking that I might need to use VBA for this, but I really would prefer not to, since I don't need VBA for anything else in this workbook.