WOW thanks for the help that is exactly what I needed.

"Jim Thomlinson" wrote:

Perhaps this...

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

Jim Thomlinson


"Jane Griffel" wrote:

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.