Results 1 to 19 of 19

Populate cells based on category chosen

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2010
    Location
    Jamaica
    MS-Off Ver
    Excel 2003
    Posts
    92

    Populate cells based on category chosen

    Hello Experts Please help me with the below task

    The attached file has on two sheets, the first sheet named inventory list has on inventory items that will go into recipes. These inventory items are assigned to specific categories.
    On the sheet named “Recipes” when I select a category from the drop down list located in cell A19:A28. I need to see all the inventory items belonging to that category in the drop down list under the heading “Recipe Inventory” located in cells D19:D28.

    Example: when I select the category “chicken” in cell A19 I need to see in the drop down list in cell D19 all the inventory items belonging only to the Chicken Category so I can make my selection. After I have selected the inventory item from the drop down list, I need column ‘C’ (item Code), Column ‘E’ (Recipe Unit Price ) & Column ‘G’ (Recipe Unit) to be populated with the data for that item. All these data are found on the sheet named “Inventory list”


    Thank You
    Teddy
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Can I auto-populate a list from another table based on a shared category?
    By Freddy! in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-04-2019, 06:43 AM
  2. Chart - Category Label Disappears if the 1st Category not chosen
    By RebeccaD747 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-04-2019, 11:52 PM
  3. Narrowing or Expanding Questions listed based on category(s) chosen
    By OVacctng in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-21-2016, 12:17 PM
  4. Replies: 12
    Last Post: 01-13-2015, 09:30 AM
  5. [SOLVED] Form items chosen in Listbox to populate specific cells in spreadsheet
    By floydian in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-14-2013, 07:48 AM
  6. [SOLVED] Populate cells when Month is chosen in combobox for a specific name
    By SChapman in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 05-17-2013, 06:14 AM
  7. Populate ListBox Based On Item Chosen In Another ListBox
    By davemojo82 in forum Excel General
    Replies: 1
    Last Post: 08-04-2009, 08:39 AM

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