Hi,

I have a drop down button in the colum called Items that is linked to a list
on another sheet. each row in that column has the ability to list all the
items by selcting the drop down button. I have may items, I want to either
press the button and selct from the list or, have the item populate the field
as I type, similiar to what Acces does or any database will do. You know,
that automatic fill.

Example, I could select the item "apple" from my list or just type "ap" and
have the blue indicator go to that item, hit enter. and the field is
populated. Can this be done in Excel, or shuold I use Access for this
project. I am better in Excel.

Thanks for your help

"BigPig" wrote:

Hi rick,

Is your 'list' a 'static ' list? Meaning does it change much? And, when you
say, "I want to scroll up and down..." do you mean that you want to edit that
list, or something else in another column? Could you explain a little more?