+ Reply to Thread
Results 1 to 3 of 3

Dynamic Data Validation List from a Table

  1. #1
    Registered User
    Join Date
    12-01-2015
    Location
    Indonesia
    MS-Off Ver
    MS Office 2019 and 365
    Posts
    98

    Dynamic Data Validation List from a Table

    Dear All..
    Please help to create a dynamic data validation list from the data in the "ITEM" table so that in cell F2 there will be a data validation list that matches the date in cell E2, the data validation list in F3 will also match the date in cell E3 etc. In addition that the data in the ITEM table will grow steadily every day.

    Thank You
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Dynamic Data Validation List from a Table

    Create a defined name with CTRL + F3 and use the following formula in the validation. It only works if the table is sorted by date.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Messages have been translated from Dutch to English by means of google translate.

  3. #3
    Registered User
    Join Date
    12-01-2015
    Location
    Indonesia
    MS-Off Ver
    MS Office 2019 and 365
    Posts
    98

    Re: Dynamic Data Validation List from a Table

    Dear Vraag en antwoord..

    Thank you for your help..That's exactly what I needed.

+ 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. Dynamic Drop-Down List Data Validation Issue for Multi-Rowed Table
    By Kogen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2020, 09:10 PM
  2. [SOLVED] How can I add a new item to a dynamic validation list without adding to source table
    By chris01395 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-20-2020, 06:58 AM
  3. [SOLVED] not showing duplicates in data validation list from dynamic table
    By jaryszek in forum Excel General
    Replies: 26
    Last Post: 08-14-2018, 03:12 AM
  4. Replies: 1
    Last Post: 01-14-2018, 11:04 AM
  5. Dynamic Data Validation List Using Pivot Table
    By seethesun in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-05-2016, 11:02 AM
  6. Dynamic Validation List from DB Like Table
    By codewalk3r in forum Excel General
    Replies: 3
    Last Post: 09-02-2015, 10:16 AM
  7. [SOLVED] Data Validation List to Return Variable/Dynamic Data based on Reference Table
    By dilbert1865 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2014, 09:08 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