Dec 22 2018 08:14 AM
I am creating an order form for a small business. The form has all of the items available to purchase. When an employee works on an order for a customer, they will put a quantity in the "Quantity" cell.
I want the macro to hide any row that has a quantity of "0".
This is my first attempt at writing Macros, so please be very specific. The screen shot is of the order form as it is currently designed.
Dec 22 2018 09:46 PM
Hi,
I have non-macro solution for your, I would suggest you convert that entry data into Excel Tables & insert the slicer for qty. When generating invoice select all and once you are done with your entry filter out the qty 0 unselect it.
Hope you find this solution helpful and easy.
Regards, Faraz Shaikh
Dec 31 2018 09:13 AM
Hi, If you are still looking for a VBA solution, just change "For i = 17 To 27" to the appropriate row numbers for your range that you want to hide row with a 0 in column J.
Sub HideRows()
Dim i As Integer
For i = 17 To 27
If Cells(i, 10).Value = 0 Then
Rows(i).EntireRow.Hidden = True
End If
Next i
End Sub
Sub UnHideRows()
Rows.EntireRow.Hidden = False
End Sub