I have a blank invoice layout in excel.
I need to have it ask the user when they either open the file or when they
click on cell for customer #
user then enters it -select enter
excel then goes to my sql db and finds customer # and pulls and populates
sold to address area in excel, then prompts user for ship to same as sold
-yes or no.
if yes fill in ship to if no then user can fill this in.

Any ideas on how to do this