If function with printing toolClosed

Question

I have 3 column " Nu, Item, QTY"  I want to print the cell who has a qty with the same Nu sort.
	nu         item                           qty
	1         Vanilla                          5
	2         Mango                         0
	3         Galaxy                          0
	4         Chocolate                    1
I want to hide Mango and Galaxy in printing and keep the nu sort Vanilla first then Chocolate.
Thanks

ac3mark · Answer

Try this filter:

Worksheets("Sheet1").Range("A1").AutoFilter _
 Field:=3, _
 Criteria1:="<>0", _
 VisibleDropDown:=False

This looks at the third column and evaluates it for being greater than 0.

If function with printing tool

1 reply

Similar discussions

Subscribe To Our Newsletter!