Forum Discussion
Price list - Order form-Summary page
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 e...
Please clarify your requirement by SPECIFYING your inputs and desired outputs.
input worksheets are product numbers, descriptions, and prices with a qty column. When quantities are added it calculates an extended price.
There may be as many as 500 individual products in a worksheet.
There are are several of the product work sheets.
I want to write a summary page that looks at all of the input worksheets and selects any lines that have quantities.
I have ave a work around version by having the summary contain all the lines in all of the sheets and then filtering out zero value lines.
This would be easy in Access where we could write a query to pull only non zero lines. But I am trying to provide a simple reliable tool for customers.
Thank you for your help.