Hi,

Please refer to the following link on Debra's site to get a solution to your
problem

http://www.contextures.com/xlDataVal02.html

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"wireman" wrote in message
...
I need to create lists which comprise data based on a selection from a
prior
list. Example: Manufacturer list= Vendor1, Vendor2. The next list we will
call Type list. If Vendor1 was selected from Manufacturer list the Type
list
needs to refer to that Vendors Types. How can this be done?