Extract data based on 1 criteria

Allie,

The attached is extremely rudimentary, but should either do the job for you, or get you on the right road. Bascially, the N Numbers in column K of your Order Template are copied across to the NEW Import Sheet (every one of them, so you can add more to the Order template no problem) and:

=IF('Order template'!L2>0,'Order template'!L2,"")

tells Excel to display a number if it finds one in Column L of the Order Template which is greater than zero, and if it does not, to return a blank.

It's then simply a matter of filtering Column B, selecting "No blanks".

Hope this helps.