Results 1 to 3 of 3

Default Value in Multiple Data Validation lists based on another cells value

Threaded View

  1. #1
    Registered User
    Join Date
    11-06-2014
    Location
    Milwaukee
    MS-Off Ver
    2010
    Posts
    12

    Default Value in Multiple Data Validation lists based on another cells value

    Long story short, sheet1 allows the user to choose what type of service is being performed with a data validation list, there will almost always be multiple line items. Sheet2 then autofills that selection into cell B10:B25 depending on how many services were chosen. Cells C10,H10:N10 then use a vlookup to fill in other criteria (located on sheet3) to assist the user in knowing what material to order, etc. Cells D10,E10,F10 & G10 have data validation lists allowing the user to choose from different materials, vendors, etc. All this was fine and well until the request was made to have the lists populate a default value that is within the list, dependent upon the service located in clmn B, and the defaults change for each of the 20+services that can be chosen on sheet1.

    I do have some experience in VBA so definitely willing to use that vs. a formula. I have attached a sample of my spreadsheet, I didn't erase all of the named tables so forgive me if its a little sloppy. I appreciate the help!!
    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. Data Validation Combo Box with Multiple Independent Validation Lists
    By firstofnine in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2016, 04:38 PM
  2. Replies: 0
    Last Post: 07-01-2015, 09:49 AM
  3. Replies: 28
    Last Post: 08-15-2013, 09:38 AM
  4. [SOLVED] Lookup Based on multiple data validation lists
    By Jason Eric in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-02-2013, 08:05 AM
  5. Default Button Reseting Data Validation Lists From Another Sheet
    By BobBing in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2012, 04:41 AM
  6. Drop down based on multiple validation lists
    By projectile in forum Excel General
    Replies: 9
    Last Post: 11-17-2011, 11:11 PM
  7. Replies: 3
    Last Post: 09-02-2010, 03:04 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