Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Validation

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Everyone.
    When I use Validation in one cell and I choose a department from that list what i would like it to do is then in the next validation automatically display a list of names for that oparticular department. Is there a way of doing this?

    thanks

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Put your department names in one list Put your names for each department in seperate lists and name those ranges with the department names. Then for your second validation, use the indirect function to refer to the first validated cell.

    send me your e-mail address and I'll send you a sheet showing this


    [ This Message was edited by: Steve Hartman on 2002-03-18 06:20 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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