Bob
I had to delete all the formula to lookup information in order to get
down to size.
Basically I have four tab the only two that apply to this situtation is
the worksheet, and list tabs.

The list tab contains the lists, I have defined the name and used the
validation rule. When I put the custom validation in it removes the
list.

The Columns that apply to the list B-G have a yes/no/blank cell list
Columns BC:BD have HB/blank cell
list

I hope this is enough information for you to understand what I'm trying
to do.

Thanks again for your help.


+-------------------------------------------------------------------+
|Filename: Direct Marketing Copy.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5018 |
+-------------------------------------------------------------------+

--
lostinformulas
------------------------------------------------------------------------
lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229
View this thread: http://www.excelforum.com/showthread...hreadid=560489