Drop Down List Questions

T

Tagg Bowman

Hi,

I have a couple of problems with drop down lists I was
hoping to get some help on:

1) The drop down lists appear with the list displayed in
the middle of the list instead on the first item, can
that be changed so the list appears at the top of the
list instead of in the middle?

2) Two of the columns are an item name (A) followed by
the item number (B). Is it possible to have the item
number in column B enter automaticly based on the name I
select in column A?

Thanks in advance, Tagg
 
D

Debra Dalgleish

There is probably a blank cell at the bottom of your list source. When
the dropdown list opens, it matches the cell value to an item in the
list, if one exists.

Delete the blanks from the source, and the problem should disappear. If
you're leaving blanks so the list can grow, you can use a dynamic name
for the range instead. There are instructions on my web site:

http://www.contextures.com/xlDataVal01.html

http://www.contextures.com/xlNames01.html

There's a sample file here that uses data validation and a VLookup
formula to fill in an order form:

http://www.contextures.com/excelfiles.html

Under 'Data Validation' look for "Order Form"
 
Top