To update the Pay Type
Just update the "Bank Charges" sheet and the drop down options will also be updated. To make it nicer, make sure the charges are in alphabetical order.
To update the Tour Company
Just update the "Tour details" sheet and the drop down options will also be updated. To make it nicer, make sure the tour companies are in alphabetical order. Make sure the tour company names are in column A.
To update the Commission Percentage
Right click on any of the "Comm%" column, then click on Drop Down to update the commission percentage.
Charges, Total Nett and Com (RM) column
Try not to change the column formula. If you have to, then please ask BID for help.
*For BID reference
Column E (Charges): =ARRAYFORMULA(IFERROR(VLOOKUP(D2:D,'Bank Charges'!A:B,2,0))) [This is to get the bank charges value from the "Bank Charges" sheet]
Column F (Total Nett): =ARRAYFORMULA(IF(D2:D="-","",C2:C*(1-(E2:E/100)))) [This is to calculate the Total Nett column. If column D is "-" then it'll just show as blank. If not, then it'll do the calculation]
Column H (Com(RM)): =ARRAYFORMULA(IFERROR(F2:F*G2:G)) [This is to calculate the commission to be paid using the Total Nett column multiplied with the Comm% column]