I use Excel 2000 9.0 as a pruchasing program.
I would like for Excel to recognize which vendor
I enter into column c, and then automatically enter
who my sales rep is into column J.
I also would use this same method to recognize
item descriptions in column D and automatically
input the respective part numbers.
Thanks in advance,