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.
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.