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
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies