This VBA script will do the following:
-
save the kronos 401a xls as an xlsm
-
import vba code into new xlsm file and create a module
-
delete the first 7 rows
-
merge rows that have the same SS# (Should only be two in this environment)
- add data (money) contained in either Column G or H (Only one of them)
with data (money) found in either Column I, J, or K (Only one of them).
- add data (money) contained in either Column G or H (Only one of them)
-
Column G & H totals needs to have this formula applied. =MIN(Column*100%,125)
-
clear contents of remaining rows after last entry
-
merge two remaining columns together
-
save the kronos export xlsm file into a csv
TODO: Refine the VBA so we can manipulate variables and cells without using .Select or .Activate https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba/10717999#10717999