I need to select a value from my drop down list and the code will look at three values in a database then put them in three next to where the drop down list is.
Here is the info for you.
Worksheet is called TEST
Drop down list is in column B
Cells awaiting data are in column C, D, E