I have created a pivot table for our bill of materials for all of our jobs,
in which the drawing numbers contains both numbers and letters. We want to
do a "where used" list. When I hit the drop down arrow, all of the items are
there, but in no real order. Is there a way to make them come up in
alphabetical/numerical order? Also, is there a way to type in the
number/name of the drawing that we are looking for?