I have looked at several methods but want the cleanest (easiest) way to bring
data from another worksheet in the same workbook based on a user selection
from a combo box. Combo Box to show customer name (I can do this) but would
like to automatically fill anothor cell with related data (customer's
discount) from a table not seen by user.