+ Reply to Thread
Results 1 to 3 of 3

data validation list from another worksheet

Hybrid View

  1. 09-12-2008, 08:27 PM #1
    -Brian-H-
    -Brian-H- is offline
    Registered User
    Join Date
    02-01-2004
    Location
    New Hampshire
    MS-Off Ver
    2002, 2003
    Posts
    50

    data validation list from another worksheet

    can i populate a list in worksheet 1, cell a1 from a list on sheet 3, cells c1-10?
    Brian
    Reply With QuoteRegister To Reply
  2. 09-12-2008, 08:41 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,947
    Create a named range on sheet3 then in your data validation criteria the source will be: =mylistname
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 09-13-2008, 03:15 PM #3
    -Brian-H-
    -Brian-H- is offline
    Registered User
    Join Date
    02-01-2004
    Location
    New Hampshire
    MS-Off Ver
    2002, 2003
    Posts
    50
    Wow!, Cool! thx
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Validation List That Ignores The Blank Cells
    By nevi in forum Excel General
    Replies: 4
    Last Post: 06-12-2008, 03:54 PM
  2. How do I use VBA to choose the source cells for a list with Data Validation?
    By baconcow in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-11-2008, 05:36 PM
  3. Data Validation List - Unique Values from a List
    By kwsmith in forum Excel General
    Replies: 0
    Last Post: 07-17-2007, 04:56 PM
  4. producing a list from data from another worksheet
    By Tin in forum Excel General
    Replies: 0
    Last Post: 06-03-2007, 02:05 PM
  5. Data Validation List
    By edwardpestian in forum Excel General
    Replies: 1
    Last Post: 04-28-2007, 01:24 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1