Results 1 to 2 of 2

Auto Populate Dynamic List Using Data Validation Drop Down

Threaded View

  1. #1
    Registered User
    Join Date
    01-12-2017
    Location
    Fort Myers, FL
    MS-Off Ver
    2013
    Posts
    3

    Question Auto Populate Dynamic List Using Data Validation Drop Down

    I have been trying to find out if this is even possible, so far I haven't been able to get an answer online...

    I am trying to create a running list based on choices made with Data Validation drop down menus in multiple cells. (FYI - Some of these cells also use VLookUp to account for variables, and the list I am trying to create needs to draw from 2 different sets of data.)

    Basically, I want to create a detailed cost breakdown of items which I use on a daily basis. Each item has multiple cost factors, some of which need to be purchased and some of which I already have in stock (in stock costs do need to be included).

    I created a sheet which details individual line items for the cost factors of each item I use, which separates these costs into the 2 data sets, purchase & in stock; it's important that I have the distinction between the 2 data sets for internal purposes. (I also want to point out that not every item has an in stock component, so I don't know if this would have an affect but felt it pertinent to mention.)

    So the idea is, on Monday I can choose the items I will need to use through the Data Validation drop down menus I've created, and the corresponding costing line items will be auto populated onto a third sheet to create an total accumulative breakdown of all costs for the whole week. I understand there will be redundancies, but having this comprehensive detailed list is the objective.

    This seemed simple in my head, but as I work through all of the moving parts - I am finding that it is not! Is there any hope for me?! If anyone could offer a hand, I'd be truly appreciative.

    I've attached a version of what I have created, so that you can better understand this unintentionally complicated spreadsheet.

    Thanks in advance for any help you can provide!!!
    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. Replies: 1
    Last Post: 06-26-2017, 02:12 PM
  2. [SOLVED] Dynamic Offset Formula to populate a Data Validation list
    By TC1980 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-09-2017, 11:27 AM
  3. Data Validation list that will Auto drop down.
    By kod1ak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-15-2014, 08:34 PM
  4. Populate cell data based on data validation (drop down list)
    By ish_baho in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-05-2014, 11:47 PM
  5. Data Validation-Auto populate from a drop down menu
    By Shannonm2706 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-23-2013, 11:00 AM
  6. Replies: 3
    Last Post: 02-28-2012, 11:54 AM
  7. Reversing a Dynamic Drop-Down List in Data Validation..
    By e4excel in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-18-2008, 02:09 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