Apply data validation using multiple named ranges

**jburban2** · 10-20-2009, 03:24 PM

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!

**jburban2** · 10-20-2009, 03:38 PM

I'm in Excel 2007.

Forgot to attach an example file - here is one. The only two differences between that file and the real one are:

1- The named ranges are on a different page
2- There are about 2000 rows instead of 5

Thanks again!