I am new to using Excel 2007. I have figured out how to create a drop down
list using Data Validation but I need help making it function the way that I
need it to in a sales order.
I created the original drop down list of "customers."
If Customer "A" is chosen on that list, I need Customer "A"s address to come
up on the sales order as well.
Can someone eplain how I would go about setting this up?