Good morning,
Currently I have 1 doc with 2 pages.
page 1 = 2 separate pricing matrixes (grouped)
I am calling them lights and darks.
example of one:
-------------------1----------2-----------3-------------4---
23-56---------$5-------$10--------$15--------$20
57-78--------$10-------$15-------$20 --------$25
79-101------$15-------$20--------$25--------$30
page 2 = quote sheet
In this sheet I have a drop down menu with 2 options (lights, darks).
This way a single matrix is used for reference.
There are 2 cells that must be filled with a number to reference what the price is with a final cell that displays the total.
cell 1 = quantity (rows) ex: 60
cell 2 = number of embellishments (columns) ex: 3
cell 3 = price (row/column total) ex: $20.00
Could use some help with the drop down also.
I don't know how to specify what group is used for reference when that option is selected.
Thanks in advance and appreciate any feedback.
Bookmarks