I have a Name Range (e.g. Company) which comprises of cells A1:A100, however values have been entered until A1:A40, the rest have been kept empty intentionally for future use. I am using this Name list (Company) in cell B1 for use, however the drop down is a big one and also displays the empty ones. Is there a way to display only the ones with value in B1 drop down.
Bookmarks