+ Reply to Thread
Results 1 to 8 of 8

Choose an item from drop down list--> populate mulitple parts and their prices below

  1. #1
    Registered User
    Join Date
    01-20-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    5

    Choose an item from drop down list--> populate mulitple parts and their prices below

    ISSUE #1 A I would like to be able to choose a Size from a drop down list.
    B After choosing the size, the Parts and Price records (rows of data) will populate below a few cells.
    C I will manually insert the Quantity amount of items I need,
    D This will calculate the total from the cells (price & Qty).
    Attached Files Attached Files
    Last edited by jaimem00; 05-27-2013 at 10:07 AM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Choose an item from drop down list--> populate mulitple parts and their prices below

    There doesn't seem to be any data related to the values B4, C4, F4 etc.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    01-20-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Choose an item from drop down list--> populate mulitple parts and their prices below

    Sorry, i was just referencing the sizes that I would have in the drop down. 2, 4, 5,7 etc

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Choose an item from drop down list--> populate mulitple parts and their prices below

    Sorry, I still don't really follow.

    How do the sizes relate to the parts?

    Where are the sizes on the worksheet you uploaded?

  5. #5
    Registered User
    Join Date
    01-20-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Choose an item from drop down list--> populate mulitple parts and their prices below

    Sorry,I made a mistake, the sizes are next to the parts at the top of the tables.
    they have prices under each different size.

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Choose an item from drop down list--> populate mulitple parts and their prices below

    Are these the sizes?

    4"-15M 5"-10M 5"-15M 7"
    Last edited by Norie; 05-26-2013 at 04:40 PM.

  7. #7
    Registered User
    Join Date
    01-20-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Choose an item from drop down list--> populate mulitple parts and their prices below

    2" 4"-10M 4"-15M 5"-10M 5"-15M 7"

    These are them. From both tables.

  8. #8
    Registered User
    Join Date
    01-20-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Choose an item from drop down list--> populate mulitple parts and their prices below

    I have updated the original file, this should explain what I want to accomplish. Thanks for all your help and guidance.
    Attached Files Attached Files
    Last edited by jaimem00; 05-27-2013 at 10:08 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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