If by dropdown you mean Data Validation, then name the range e.g. myrange, on
your other worksheet and in Data Validation select

Allow: List
Source : =myrange

HTH

"John Baylis" wrote:

I am trying to use a dropdown selection in excel to pull data from a list on
another work sheet to fill in multiple cells.