Build an excel spreadsheet that generates price quotes based on the selection criteria.
- Spreadsheet contains a workbook-1 with a price list - items and a corresponding price of each item.
- A workbook-2 contains “solutions” with a list of supported solutions. Next to each solution, I want to be able to fill in a quantity desired.
- There will be a way to tie “solutions” and a corresponding “items” from the price list. Some solutions need more than one item. I need a way to make some of these items required for each solution and others will be optional. I want to have an automatic selection of items based on manually selected solutions and a set of corresponding rules.
- Based on the selections and what has been pre-programmed as required or optional, generate a list of all selected items in the workbook 3.