Hello experts! I am stumped - but I have confidence what I want is attainable. I have a program that will use an Excel spreadsheet document template to fill with a parts list. There is a Quantity column and supplier option columns. I am looking for a way so show the user the matrixed data where the supplier option columns have a clickable on/off or true/false so when I click a supplier choice, the unit price from that supplier is multiplied by the qualtity to produce an extended cost. I can get everything to work except I am at a loss on how to make the cells for supplier options clickable so the extended price is calculated on my choice. I could delete the other supplier costs but then I lose data. I just want to be able to select sort of like "what if"... Sure could use help! Thanks in advance for suggestions.
