need to allow sales input data in a form of table to excel and the excel need to calculate the commission rate depending on various factors inputed.
need to use drop down list and need do data validation. need lock the excel cells to make sure the “formula” cannot be modified by sales persons.
for details, please send me message.
