Drop down on every Line for a specific column?

[Can-A-Funk]

Hi,

I am entering data into a spreadsheet and then saving it as a .CSV fil
so I can upload it to my site and minipulate the data.

For example I have fields (column's) "ID", "Manufacturer", "Model"
as per picture below. I want to have a list of Manufacturers in
drop-down so I can eliminate spelling errors ect. But I want to hav
the dropdown on every line as I go down...

Can someone help me

+----------------------------------------------------------------
| Attachment filename: sheet.jpg
|Download attachment: http://www.excelforum.com/attachment.php?postid=367264
+----------------------------------------------------------------

 

[Don Guillett]

Easiest is to select the range before applying data validation

 

[Can-A-Funk]

Hi ,

Thanks for you help but can you elaborate on your comment.

I have included a list of Manufacturers for you so if you can try i
out maybe....

Kind Regards,

Can-A-Fun

+----------------------------------------------------------------
| Attachment filename: manufacturers.txt
|Download attachment: http://www.excelforum.com/attachment.php?postid=367390
+----------------------------------------------------------------