I am creating a template for our sales staff to use for quoting.
I am listing product with selected criteria and coming up with a price.
However, all product will show on the excel template file and I only want
items that are selected to total.
I know I don't want to use a columun for QTY and multiply the parts with cost.
Some items will not have Qty values but I want to select them on the quoting
process.
Ex. Washer
* (box/selection item) 3-stage washer 30,000
* 5-stage washer 50,000
* 7-stage washer 70,000
And if possible, the one selected above to only show on the quote and add
with other selected criteria. I hope I explained this well enough.
Any suggestions. Thank you for any help you can give in advance.