I'm trying to create a drop down list box in my excel sheet that is populated
by a list of values. For each cell in the column I want this drop down to
appear.

It's effectively a pick list ..

Any ideas on how to do this?

Thanks