+ Reply to Thread
Results 1 to 3 of 3

Need to generate all the different possible outcomes based on multiple drop-down selection

  1. #1
    Registered User
    Join Date
    04-21-2014
    Location
    Edmonton, AB
    MS-Off Ver
    Excel 2013
    Posts
    4

    Need to generate all the different possible outcomes based on multiple drop-down selection

    I have created a part number / description / price configurator for one of my product lines and I would like to use it to create all the different combinations for all the different options. If my calculations are correct there are about 54,000 different possibilities which would take too long to enter individually. I have 6 drop down lists, 3 of which are dependent on the first selection, which creates a BOM cost, list price, part number and description. I have attached a screen shot to help. Any suggestions would be very much appreciated.

    Thank You!
    screen Capture.GIF
    Attached Images Attached Images
    Shane K.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Need to generate all the different possible outcomes based on multiple drop-down selec

    Picture:

    Hi and welcome to the forum

    Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome (manually entered is ok) and how you arrived at that. (Exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you. Also, not all members can upload picture files (Company firewalls, etc.)

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    04-21-2014
    Location
    Edmonton, AB
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Need to generate all the different possible outcomes based on multiple drop-down selec

    I have attached the workbook in question. The main tab "Configurator" contains all the lists which need to be selected. I have created a sample of the output I would like on the "Export List" tab.Chain Sling Price Calculator-9-gr80.xlsx

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Returning data across multiple sheets based on drop down list selection
    By rooboyz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-29-2014, 02:41 AM
  2. Selecting data from multiple tabs based on drop down selection
    By ramakrishnavbms in forum Excel General
    Replies: 2
    Last Post: 04-10-2013, 01:47 PM
  3. Replies: 5
    Last Post: 01-10-2013, 06:22 PM
  4. Multiple results to display based on selection made from drop down list
    By scoot_eruk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2012, 05:03 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1