tarekgemayel
07-20-2014, 12:37 AM
Please refer to this attachment 11994.
I have a userform where you can pick a Customer from a drop down list and also a product from a drop down list.
Depending on the customer and product chosen, a Discount must be applied.
That specific discount is located on sheet "Customers" in a table whose rows are the Customers and columns are the Products.
Once I have chosen the customer and the product, how can I extract the discount matching my selection?
Please refer to the attached excel file and fill in the code in the section indicated.
Thank you all :)
I have a userform where you can pick a Customer from a drop down list and also a product from a drop down list.
Depending on the customer and product chosen, a Discount must be applied.
That specific discount is located on sheet "Customers" in a table whose rows are the Customers and columns are the Products.
Once I have chosen the customer and the product, how can I extract the discount matching my selection?
Please refer to the attached excel file and fill in the code in the section indicated.
Thank you all :)