I've done it but I'm not sure how! Thanks for your help though!

"excelent" wrote:

in sourse box type:
=A:A
or
=B:B or what ever


"wanderer83" skrev:

I don't quite know what you mean by defined?

"Toppers" wrote:

How is your list defined? It should (does for me!) work as Barb's posting.

"wanderer83" wrote:

I did that and selected an option from the list, and then in the cell below
tried to selct an option from the list but the option from the cell above was
not there. the options seemed to be disappearing from the list when I
selected them!

"Barb Reinhardt" wrote:

Try copying the first cell down as far as you want.

"wanderer83" wrote:

I have created a drop down list for the first cell in the column using the
data, validation method but I want the list for each cell in the column. How
do I do this without having to go to each cell to create the list?