Okay, here is one that I can't seem to find anyone else has asked. Or at least I'm looking up the wrong terms.
In Cell J9: Drop down list with 4 options -Manufactuer 1,2,3 and "Other"
In Cell J10: Drop down list referenced to 3 tables based on the 3 Main manufacturers from J9, the "Other" would allow the user to enter custom information.
To this point in the past I have used a macro to "clear" what is present in J10 and then require the "Other" information to be entered into J11.
Is there a way that when "Other" is selected to allow the Drop Down list to be either conditional or allow for a custom entry in the J10 cell?
Thank you in advance
In Cell J9: Drop down list with 4 options -Manufactuer 1,2,3 and "Other"
In Cell J10: Drop down list referenced to 3 tables based on the 3 Main manufacturers from J9, the "Other" would allow the user to enter custom information.
To this point in the past I have used a macro to "clear" what is present in J10 and then require the "Other" information to be entered into J11.
Is there a way that when "Other" is selected to allow the Drop Down list to be either conditional or allow for a custom entry in the J10 cell?
Thank you in advance
