I have a drop down list on Column B showing different categories (Sales, Sales-Adhoc, Repair, Maintenance & Others). When the user select Category, I would like the Reference No to reflect the type of Category selected.
For example, if user select Sales under Category, Sales will be represented by S and be shown as QTN-S-1501, instead of QTN-Sales-1501
P.S. The table on the right showing Category and Code is just a legend, not part of the table log.