Forum Discussion
Extracting data using a Dropdown list that will auto generate in another sheet.
I am very new to excel so excuse my lack of knowledge. I am trying to get information in a row to auto populate in another sheet when I select an item from a dropdown list. So, if I choose "dual" in ...
I was looking at the code and in the other workbook I am working on in the "DUAL" I made it a hyper link. On the one you worked on the "dual" drop down is not a hyperlink. I was think this as the reason it was not working for me.
Does it work if you change
If rng.Value = "Dual" Thento
If LCase(rng.Value) Like "*dual*" Then