+ Reply to Thread
Results 1 to 2 of 2

Automatic data input after selecting data validation in different cell.

  1. #1
    Registered User
    Join Date
    06-18-2014
    Location
    Indonesia
    MS-Off Ver
    2007
    Posts
    9

    Automatic data input after selecting data validation in different cell.

    In cell E I created data validation menu. Types of VISAS (source data is J till Q). In cell F i want automatically the days of validation coming up after selecting the type of visa in cell E. (the data source from that is R till Y).

    How can I do this?
    Attached Images Attached Images
    Last edited by edwink85; 12-20-2018 at 10:03 PM.

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,366

    Re: Automatic data input after selecting data validation in different cell.

    Please dont' put an image, no one is looking after your post, try upload your sample excel file, click on "Go advanced" button, then scroll down to find "Manage Attachments" text button to attach the file.


    Terima kasih

+ 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. [SOLVED] data validation help: referencing one cell and selecting data from the adjacent cell
    By gunsafety in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-18-2018, 04:21 PM
  2. Restrict Input to One Cell or Another Using Data Validation
    By Era715 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2017, 01:09 PM
  3. Editing Code: Selecting multiple items in a cell via data validation
    By baker2145 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 06:13 PM
  4. Run Macro when selecting from in-cell list (data validation)
    By 4am in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-08-2010, 04:57 PM
  5. Using a cell on another worksheet as input for data validation
    By gessie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2008, 09:53 AM
  6. Data from Input Box overrides cell input validation
    By Winon in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-01-2007, 02:29 PM
  7. Data Validation does not work when selecting another cell.
    By Simon Jefford in forum Excel General
    Replies: 5
    Last Post: 06-29-2005, 07:05 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