Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Durham, North Carolina, USA
    Posts
    140
    Thanks
    5
    Thanked 1 Time in 1 Post

    Data Validation using source from other worksheet (97/XP)

    Howdy,

    I could swear I've seen this done, but I don't how they did it.

    I want to use the Data Validation feature to create drop-downs for easy data entry into the cells of a column. The list of allowed values is kept on a separate sheet in my workbook. Excel tells me that the source for the list values can not be on another sheet.

    Anyone got a fix/alternative? I'm not afraid of a little VBA if necessary, but I don't know if the client will go for it.

    Thanks in advance for any help.

    Beej

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Data Validation using source from other worksheet (97/XP)

    See <post#=343318>post 343318</post#> for a spreadsheet with an example of how to do this.

  3. #3
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data Validation using source from other worksheet (97/XP)

    First give a Name to the List range ( <font color=red>MyList</font color=red> ) (on your Other Wsh)
    Then in Data Validation select <font color=blue>List</font color=blue>
    In the refers to box enter <font color=red>=MyList </font color=red> (Be sure to enter the equal sign)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •