I have a sheet pulled down from a SQL server. It has data similar to this.

Col A Col B Col C
1001 ABC 111
1002 ABC 111
1003 ABC 111
1004 DEF 222
1005 XYZ 333
1006 XYZ 333

Column C is the data entered. This creates a list in the next cell to choose one of the three items for that data picked...in this case 111. Once the entry is made from those choices, the rest of the information is automatically populated, i.e. address, zip, contact, number.

I have got the first part and the third part (found it on this site BTW). I just can't firgure out how to create the drop downs from the file above from the information entered. I would prefer not to have to recopy the information since it is dynamic and the file is used daily.


Cheers,
Betsy