Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Montreal, Quebec
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi gang,
    In my workbook I have 1 sheet for Appointments and 1 sheet for client Coordinates.
    I have named a range (Clients) on the Coordinates sheet that contains the clients names and I use it on my Appointments sheet to validate the client name when entering a new appointment.
    My range Clients is defined to be much bigger than the number of names I have right now on the Coordinates sheet.
    How can I restrict the number of names appearing on my validation list to include only clients that I have right now and not all the blank cells as well.
    I don't want to redefine my list everytime I get a new client.
    tks.
    Johanne Champagne
    Montreal (Quebec) CANADA

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Use a Dynamic Named Range - then use that Named range in your validation. I've attached an example.
    Attached Files Attached Files

  3. #3
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Montreal, Quebec
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That was quick and it did the trick.
    Thanks alot.
    I have another one. I will start a new thread.
    tks.
    Johanne Champagne
    Montreal (Quebec) CANADA

Posting Permissions

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