Hello,
I'm trying the create a drop down list in a cell. The list source is a range with 20 rows. All cells in the range may be populated. At times only a few will be populated. How do I get the drop down list to show only the cells that have data in them, not the zeros in the range?
Also can I always have the first cell in the range show on the drop down list?
Thanks for any help.