CHALLENGE

​

This client was using a third party software application to export a csv file that included payroll data for each employee. The client was unhappy with the look of the exported csv file due to unnecessary columns and irrelevant data.

​

SOLUTION

​

We were able to create a complex Excel VBA script that sorted all the employee's names from A-Z, color code each location, delete unwanted data, format columns and spacing, and add in formulas to calculate the total number of hours each employee worked with a push of a button.

​

BENEFIT

​

Instead of the client manually having to make all those changes weekly, now all they have to do is open our Excel file and the user is automatically prompted to import the csv file and our VBA code does the rest within seconds. This allowed the client to be more time efficient and eliminated the risk of any user errors.