View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Todd[_7_] Todd[_7_] is offline
external usenet poster
 
Posts: 5
Default Combo Box Value List

Hi,

If I have input cells for five people:

person 1 = John
person 2 = (empty)
person 3 = Mary
person 4 = (empty)
person 5 = Steve

What do I do to consolidate the list elsewhere in the
sheet (eliminating the empty cells) so that I can use the
condensed list as the possible variable for a combo box?

John
Mary
Steve

In addition, the input fields are constantly changing and
the scenario is different each time.

Thanks for you suggestions,
Todd