If function with printing tool

Posts
1
Registration date
Tuesday November 13, 2018
Last seen
November 13, 2018
- - Latest reply: ac3mark
Posts
10940
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 14, 2018
- Nov 13, 2018 at 09:15 AM
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
See more 

Your reply

1 reply

Posts
10940
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 14, 2018
0
Thank you
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.
Respond to ac3mark