Home

Excel Spreadsheet Bill-of-Materials - Need to be able to select a supplier

%3CLINGO-SUB%20id%3D%22lingo-sub-463224%22%20slang%3D%22en-US%22%3EExcel%20Spreadsheet%20Bill-of-Materials%20-%20Need%20to%20be%20able%20to%20select%20a%20supplier%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-463224%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20experts!%20I%20am%20stumped%20-%20but%20I%20have%20confidence%20what%20I%20want%20is%20attainable.%20I%20have%20a%20program%20that%20will%20use%20an%20Excel%20spreadsheet%20document%20template%20to%20fill%20with%20a%20parts%20list.%20There%20is%20a%20Quantity%20column%20and%20supplier%20option%20columns.%20I%20am%20looking%20for%20a%20way%20so%20show%20the%20user%20the%20matrixed%20data%20where%20the%20supplier%20option%20columns%20have%20a%20clickable%20on%2Foff%20or%20true%2Ffalse%20so%20when%20I%20click%20a%20supplier%20choice%2C%20the%20unit%20price%20from%20that%20supplier%20is%20multiplied%20by%20the%20qualtity%20to%20produce%20an%20extended%20cost.%20I%20can%20get%20everything%20to%20work%20except%20I%20am%20at%20a%20loss%20on%20how%20to%20make%20the%20cells%20for%20supplier%20options%20clickable%20so%20the%20extended%20price%20is%20calculated%20on%20my%20choice.%20I%20could%20delete%20the%20other%20supplier%20costs%20but%20then%20I%20lose%20data.%20I%20just%20want%20to%20be%20able%20to%20select%20sort%20of%20like%20%22what%20if%22...%20Sure%20could%20use%20help!%20Thanks%20in%20advance%20for%20suggestions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-463224%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-463326%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Spreadsheet%20Bill-of-Materials%20-%20Need%20to%20be%20able%20to%20select%20a%20supplier%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-463326%22%20slang%3D%22en-US%22%3EI%20find%20it%20impossible%20to%20understand%20what%20you%20mean%20unless%20you%20attach%20your%20sample%20file%20with%20sample%20data%20and%20sample%20results.%3C%2FLINGO-BODY%3E
russellsteiner
Occasional Visitor

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.

1 Reply
I find it impossible to understand what you mean unless you attach your sample file with sample data and sample results.
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies