ScoobyDoo
09-24-2012, 07:39 AM
Hello all,
I have two columns. Column A is where the user types data, column B is where the item is categorised with a dropdown. What I am looking for is a way to dynmacially set the dropdown dependant upon what is entered in column A. So if the word loan is in cell A2 then the dropdown in cell B2 should be set dynamically to "other", without the user selecting. But there should still be a way for the user to categorise other items or edit the dynamically set category. Ideally I would like to do this without VB as it should set as the user is inputting data, but open to what is feasable. I have attached an mockup to demonstrate.
Does anyone know if this is possible? :think:
I have two columns. Column A is where the user types data, column B is where the item is categorised with a dropdown. What I am looking for is a way to dynmacially set the dropdown dependant upon what is entered in column A. So if the word loan is in cell A2 then the dropdown in cell B2 should be set dynamically to "other", without the user selecting. But there should still be a way for the user to categorise other items or edit the dynamically set category. Ideally I would like to do this without VB as it should set as the user is inputting data, but open to what is feasable. I have attached an mockup to demonstrate.
Does anyone know if this is possible? :think: