VBA mini project -- 3
Budget: $80 – $240 HKD
This tab contains employee data submitted by a client
(Columns E-G) For each employee, clients are required to provide the function code, discipline code and career level that corresponds to the job that the employee is currently in
All the information you need to understand the function code, discipline code and career level are provided in subsequent tabs
(Columns I-K) For each employee, clients are also required to provide us with their base salaries
Using just information in this file, create a VBA function to run an automatically scan of the data to check for the following
1) Abnormalities when comparing the Internal Position Title vs. Function and/or Discipline code. The VBA should put a brief comment in column I indicating what abnormalities are
2) Any abnomalities in the Base Salary data. The VBA should put a brief comment in column M indicating what abnormalities are
3) Finds abnormalities when comparing the Internal Position Title + Internal Grade vs. Career Level. The VBA should put a brief comment in column I indicating what abnormalities are
(Columns E-G) For each employee, clients are required to provide the function code, discipline code and career level that corresponds to the job that the employee is currently in
All the information you need to understand the function code, discipline code and career level are provided in subsequent tabs
(Columns I-K) For each employee, clients are also required to provide us with their base salaries
Using just information in this file, create a VBA function to run an automatically scan of the data to check for the following
1) Abnormalities when comparing the Internal Position Title vs. Function and/or Discipline code. The VBA should put a brief comment in column I indicating what abnormalities are
2) Any abnomalities in the Base Salary data. The VBA should put a brief comment in column M indicating what abnormalities are
3) Finds abnormalities when comparing the Internal Position Title + Internal Grade vs. Career Level. The VBA should put a brief comment in column I indicating what abnormalities are