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