I have a product sheet with quantities for various products spec'd out for a designed system. The majority of products are not used on every system so their quantity value is 0. I am in the process of automating a quote sheet that gives a breakdown of what customers are being charged and I want it to populate items on this list only if their quantity is greater than zero. If anyone can assist I would greatly appreciate it.
Product Sheet
Quote Sheet
Product Sheet
![nbvrci.png](/board/proxy.php?image=http%3A%2F%2Fi45.tinypic.com%2Fnbvrci.png&hash=411cb2fee1864f19ea4975d15bd4ccff)
Quote Sheet
![w1rop.png](/board/proxy.php?image=http%3A%2F%2Fi46.tinypic.com%2Fw1rop.png&hash=8975219ff8a2f26a3f4a7a3e1c0f37c1)