+ Reply to Thread
Results 1 to 5 of 5

Drop down list to populate cells

  1. #1
    Registered User
    Join Date
    03-18-2014
    Location
    Michigan
    MS-Off Ver
    Excel 2013
    Posts
    11

    Drop down list to populate cells

    Okay I am stuck at work trying to get something together. I am not an excel master as I just mostly do data entry/formatting.

    My problem: I have a drop down list with 6 recipes. When I select chocolate for example I want that to automatically populate different cells in the worksheet based on a standard I have created for that recipe. The recipes won't change they just have different ingredients and I want that to show up depending on what I select on the drop down list. I went into VBA and worked a little with this starting code:
    If Target.Address = "$F$3" Then
    Target.Offset(0, 1).Value = "1"

    but It wouldn't populate separately based on what I had selected in the drop down it would just populate all 6 recipes the same.

    Some insight would be greatly appreciated. I don't really want to attach the worksheet as the information on it I am bound by contract not to share.

    Thanks,

    Ryan

  2. #2
    Registered User
    Join Date
    09-24-2013
    Location
    Twin Cities, MN
    MS-Off Ver
    Excel 2010
    Posts
    91

    Re: Drop down list to populate cells

    You should dummy up the info and post an example of what you're trying to do. It should just be able to be handled with formulas - no need for VBA.

  3. #3
    Registered User
    Join Date
    03-18-2014
    Location
    Michigan
    MS-Off Ver
    Excel 2013
    Posts
    11

    Re: Drop down list to populate cells

    I attached a dummy.

    So next to Product Produced is the drop down list of the 6 dummy flavors.

    When I select chocolate I want the item/description/standard gallons under dairy liquids to populate as well as the item/description/standard pounds under ingredients. Those fields will be different based on what recipe is selected but the actual cells themselves wont change.

    Hope this helps!
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-18-2014
    Location
    Michigan
    MS-Off Ver
    Excel 2013
    Posts
    11

    Re: Drop down list to populate cells

    ^^

    If anyone has any suggestions as far as what formula to use for this type of thing I can maybe work it out myself but I am just lost atm.

  5. #5
    Registered User
    Join Date
    09-24-2013
    Location
    Twin Cities, MN
    MS-Off Ver
    Excel 2010
    Posts
    91

    Re: Drop down list to populate cells

    Sorry, I've been away from this site for a bit. Was surprised nobody jumped in with a solution for you.

    Attached is one simplistic solution. It makes use of having the liquids/ingredients data entered on Sheet2 and simply putting the needed data into cells D3->J8 on Sheet2 based on an offset. The offset is based on what "flavor" you choose on Sheet1. The cells on Sheet1 just point to the D3->J8 cells on Sheet2. Easier to just look at it than explain it! This should give you an insight into just one formulaic method of doing this. Also, no need to save the file as .xlsm since there are no macros involved. Cheers!
    Attached Files Attached Files

+ 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. Trying to auto populate cells from drop down list choices
    By textexpress in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2013, 12:47 PM
  2. [SOLVED] Using a drop down list to populate cells underneath the drop down.
    By jfgay in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2013, 04:07 PM
  3. [SOLVED] From drop down list selection populate multiple Cells
    By logcabin123 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-21-2012, 12:43 PM
  4. how to create a drop down list that will populate multiple cells after selected
    By aaronriggle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2012, 06:59 PM
  5. [SOLVED] Auto populate adjacent cells from a drop down list
    By gluktar in forum Excel General
    Replies: 4
    Last Post: 06-05-2012, 04:18 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