re: list box / combo box

Ronky

New Member
Joined
Oct 16, 2006
Messages
2
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?
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,114,381
Messages
5,547,613
Members
410,803
Latest member
lsweeney
Top