See Debra's article on dynamic validation:
http://www.contextures.com/xldataval02.html

--
Best Regards,

Luke M
"Jane Griffel" wrote in message
...
I have two customers with two different list of procedures on one report.
cell A1 has a drop down list of the customers when a certain customer is
chosen How do I write a formula so that when I choose Cutomer 1 only their
list of procedures show up in a drop down box in my procedure area.