Is it possible to program a drop down list to change according to the search
criteria. For example if €œa€� is entered into the cell, the drop down list
displays all value beginning with €œa€� in the drop down table. If €œac€� is
entered only values that start with €œAC€� are displayed ect.. ect€¦ Is there a
marco that can do this?