Basically, This is a snippet of a much longer order form. I want to have this order form automatically hide and unhide rows for results in the total column greater than Zero. Ideally, i'd have the full form on one tab and the output form on a second tab which will expand and contract with the results. I assume this to be neccessary as the if the form started with Zeros it would never be visible.
Can anyone help me out with what i'm looking for?
IF this is not possible....i have an alternative request. It would suffice to have the print output of this order form to only print results which are greater than zero.
Which ever if fine as the basic end result is to try and get an output for a customer of only what they ordered and not the rows which are not required.