Drop downs list on every line for a specific column?

C

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
+----------------------------------------------------------------
 
A

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.
 
P

Paul

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

Arvi Laanemets said:
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.
Click to expand...
 
Top