Dynamic Dropdown 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=368436
+----------------------------------------------------------------

 

[Bob Phillips]

Take a look at Data Validation.

You can select all of the cells, and then apply Data>Validation with a list
option , with your names in the list.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)