First off, this document will be saved as an Excel template once all my corrections are made.
I need a macro that runs with this template so that whenever a cell under the column named "Quantity" is left with a 0, that row is hidden. This would need to happen for worksheets STEEL V-Crimp Processed, Fittings, and Misc (It wouldn't matter on the others since there is no quantity column.)
The idea is that once the person creating a bid for a client has entered in everything necessary, he can run the macro to remove any rows that still have a 0 under the quantity column for a cleaner look!
The macro will also need to be "undone" if a change needs to be made after the macro is run the first time.
Bookmarks