View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Leef
 
Posts: n/a
Default ? sort data in a drop down box w/ initial cell entry

I have a dorp down box w/ numeric data sorting in ascending order. Can I
enter a number in the cell, ie: '6' and then hit the drop arrow to have the
data sort to numbers starting with '6' as opposed to always starting at the
top of the data list and having to scroll down to the data of choice