Results 1 to 4 of 4

Apply data validation using multiple named ranges

Threaded View

jburban2 Apply data validation using... 10-20-2009, 02:24 PM
jburban2 Re: Apply data validation... 10-20-2009, 02:38 PM
StephenR Re: Apply data validation... 10-20-2009, 02:38 PM
jburban2 Re: Apply data validation... 10-20-2009, 02:46 PM
  1. #1
    Registered User
    Join Date
    10-08-2009
    Location
    Travel
    MS-Off Ver
    Excel 2003
    Posts
    3

    Apply data validation using multiple named ranges

    Hi, I tried searching the forums for a solution to my problem, but didn't come across anything that looked similar.

    I am trying to apply data validation to a column of cells using named ranges. However, each row has a unique associated named range. For example:

    A_______B
    Birds____*
    Dogs____*
    Cats____*

    I can easily apply data validation to these three rows separately using named ranges.
    Ie three separate named ranges:
    =Birds
    =Dogs
    =Cats

    However, I need a way to quickly apply data validation to column B using different named ranges for each row because there are about 2,000 rows. Is there a way to reference text in the cells of column A that contains the name of the named range? Or maybe a bit of VB code that could do it quickly?

    Does anyone know a good solution to this problem?

    Thanks!
    Last edited by jburban2; 10-20-2009 at 02:46 PM. Reason: solved the problem

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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