+ Reply to Thread
Results 1 to 2 of 2

Data Validation without Drop-down list

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel, Access, Word

    Post Data Validation without Drop-down list

    Hi All,

    Hope you all doing well.
    My question is " How to make data validation depending without dropdown list"
    I want to choose Item Description from dropdown list and for next column relevant code to appear automatically.
    For example:
    I have a table with 2 columns
    Column A - Item Description
    Column B - relevant codes

    Item Description CODE
    Table C003

    I did something similar with indirect function but it creates drop down list which I want to avoid.

    Thanks in advance

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    Coimbatore India
    MS-Off Ver
    Office 365

    Re: Data Validation without Drop-down list

    If you looking for without drop down then you need to go for VB code to perform your task.

    Are you looking for something like this with Indirect function:
    Thangavel D

    Appreciate the help? CLICK *

+ 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. Replies: 3
    Last Post: 07-05-2015, 12:45 AM
  2. Replies: 0
    Last Post: 04-24-2015, 02:27 PM
  3. Replies: 5
    Last Post: 03-26-2015, 01:40 PM
  4. Drop Down List (Data Validation) Need to start at current value in list
    By bigmantitus in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-07-2014, 11:14 AM
  5. Data validation List: A macro to initiate drop down list?
    By dchubbock in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-11-2013, 08:12 PM
  6. Replies: 1
    Last Post: 09-05-2012, 11:39 AM
  7. Replies: 1
    Last Post: 07-08-2005, 11:05 AM

Tags for this Thread


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