I am trying to build an Ordering tool.
I have my product families (5) on individual worksheets.
These are set ups to allow customers to enter a quantity. That creates a discounted price and an extended price for all of the items in that family.
I would like to copy out any lines that have a quantity entered into a summary/order form.
So this is like Filtering for a qty larger than zero and copying only those lines to a summary page.
Is there a selectif kind of statement?
Is there another way to do this?
I appreciate your help!