re: list box / combo box
I have data that on a sheet that retrieves data ferom several other sheets. I want to have a list or combo box to allow a choice to be made but do not wish any lines of data that returna zero at any point to appear in the list or combo box. The usable data could for example come from lines of data that might not be in numerical order?
Can anyone suggest an easy way to achieve this?
I have data that on a sheet that retrieves data ferom several other sheets. I want to have a list or combo box to allow a choice to be made but do not wish any lines of data that returna zero at any point to appear in the list or combo box. The usable data could for example come from lines of data that might not be in numerical order?
Can anyone suggest an easy way to achieve this?