Drop downs list on every line for a specific column?

[Can-A-Funk]

I am entering data and would like to have a dropdown one a specifi
column on every line.

I have column's "ID" , "Manufacturer", "Model"

I want to inport or have a list of all the Manufacturers and everytim
I go on a new line I want to have the drop down so I can speed up m
entering and avoid spelling error ect.

Can anyone help?

Kind Regards,

Can-A-Fun

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

 

[Arvi Laanemets]

Hi

Create a sheet Manufacturers
Import your manufacturers list onto this sheet
Define a named range (Insert.Name.Define) Manufacturers with formula on
'Refers to' field
a) when your list has header in A1:
=OFFSET(Manufacturers!$A$2,,,OFFSET(Manufacturers!$A:$A,"<>")-1,1)
b) when your list doesn't have any header:
=OFFSET(Manufacturers!$A$1,,,OFFSET(Manufacturers!$A:$A,"<>"),1)

Select a range where you want to select manufacturers from drop-downs
Data.Validation.List - into source field enter:
=Manufacturers
etc.

 

[Paul]

Should
OFFSET(Manufacturers!$A:$A,"<>")
in each of these two formulas read
COUNTIF(Manufacturers!$A:$A,"<>")
?

Hi

Create a sheet Manufacturers
Import your manufacturers list onto this sheet
Define a named range (Insert.Name.Define) Manufacturers with formula on
'Refers to' field
a) when your list has header in A1:
=OFFSET(Manufacturers!$A$2,,,OFFSET(Manufacturers!$A:$A,"<>")-1,1)
b) when your list doesn't have any header:
=OFFSET(Manufacturers!$A$1,,,OFFSET(Manufacturers!$A:$A,"<>"),1)

Select a range where you want to select manufacturers from drop-downs
Data.Validation.List - into source field enter:
=Manufacturers
etc.

 

[Arvi Laanemets]

Yes! :-(

Thanks!

--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets

Should
OFFSET(Manufacturers!$A:$A,"<>")
in each of these two formulas read
COUNTIF(Manufacturers!$A:$A,"<>")
?