I would like to create an external list which i can then use for a drop down list in a worksheet.
Pick from list is not what I want
Drop down list comes close
is there anything else
PS
If I am in a cell(A1) I want to select a list of name, email etc which i can then update that cell with.
