+ Reply to Thread
Results 1 to 5 of 5

Select toy and quantity

  1. #1
    Registered User
    Join Date
    02-27-2016
    Location
    USA
    MS-Off Ver
    2007
    Posts
    10

    Select toy and quantity

    Hello Forum,
    My kid has 4 sets amount of money and has 3 types of toy to choose.

    If the amount of money is 8 and he selects toy A he can have 1 to 8 toys
    If the amount of money is 8 and he selects toy B he can have 1 to 4 toys
    If the amount of money is 8 and he selects toy C he can have 1 to 2 toys
    And so on
    I can make the dropdown list in G2, G5, G8, & G11 to select the toy but cannot make the
    dropdown in H2, H5, H8, H11 to work with the QTY in column E
    How can I create the dropdown lists in column H to select the QTY
    Thank you for your help.
    Kidprojects
    Attached Files Attached Files

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Select toy and quantity

    1) Add a list:
    O1: QTY
    O2:O33 - 1,2,3,4,5,6,7,8,9,10,11.......32

    2) Temporarily select "A" in G2

    3) Add Data Validation to H2:
    Allow: List
    Source: =OFFSET($O$2, , , B3/VLOOKUP(G2, C2:D4, 2, 0), )

    4) Copy H2 and paste over the other gray cells
    Last edited by JBeaucaire; 02-28-2016 at 01:20 PM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    02-27-2016
    Location
    USA
    MS-Off Ver
    2007
    Posts
    10

    Re: Select toy and quantity

    Hi Jerry,
    It works perfectly. Is there a way to make it works when I move the dropdown lists to another sheet so it look cleaner?
    Thank you so much for your help
    Kidprojects

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Select toy and quantity

    I've highlighted the cell in the formula above you would need to update to point the cell that has the "1" in your QTY list.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  5. #5
    Registered User
    Join Date
    02-27-2016
    Location
    USA
    MS-Off Ver
    2007
    Posts
    10

    Re: Select toy and quantity

    It works! Thank you Jerry.

+ 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] Running total of Quantity on Hand Vs Sales Vs Quantity to Produce
    By jespo1351 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2015, 07:34 AM
  2. Replies: 4
    Last Post: 01-14-2015, 07:46 AM
  3. [SOLVED] Help with VBA to Select next available quantity of stock. (FIFO)
    By JRidge in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2014, 03:26 AM
  4. [SOLVED] Select varying quantity of rows, press macro button to send selection to new workbook
    By tv69 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2013, 10:09 AM
  5. how to select price according to item and quantity
    By astrok in forum Excel General
    Replies: 3
    Last Post: 09-26-2010, 03:06 PM
  6. Divide monthly Quantity into Weekly quantity ...
    By jitendra.mistry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2010, 01:36 PM
  7. Replies: 5
    Last Post: 11-23-2009, 06:24 PM

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