Results 1 to 5 of 5

Data Validation from multiple source

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-14-2004
    Location
    India
    MS-Off Ver
    365
    Posts
    264

    Data Validation from multiple source

    Hello
    I have a name defined (Branches) and use data validation as
    Allow
    List
    Source =Branches
    It is working perfect.

    I wanted to add another text called "South" which is not defied in the list "Branches".

    So I need to allow data entry from the dropdown list (=Branches ) and "South" which is not in the list.
    I do not want to see "South" in the dropdown list but it should accept "South" if I enter it manually
    Could you please help me.
    Thanks
    Last edited by SMILE; 07-31-2016 at 05:52 AM. Reason: made it more clear
    Appreciate clicking the * Add Reputation button on your left side, if you want say thanks to me

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Data Validation - Source error
    By thedude1222 in forum Excel General
    Replies: 3
    Last Post: 09-13-2013, 09:51 PM
  2. [SOLVED] Data Validation - replace choices for multiple sheets of source data
    By mshaw1970 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2013, 07:34 AM
  3. [SOLVED] set data validation source list
    By rana_shaker in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-14-2012, 03:06 AM
  4. multiple validation dependent lists based one one source but not on each other?
    By erinkm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2012, 03:15 AM
  5. Replies: 3
    Last Post: 06-12-2012, 06:13 PM
  6. Single validation source for multiple spreadsheets
    By Sabur in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-30-2010, 11:18 PM
  7. data validation-Can the source of the validation criteria be dfrom a different sheet?
    By yael pinkert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2009, 04:28 AM
  8. Data Validation Source Box
    By Drahos in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2005, 07:25 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