I need someone who can clean up an IEX report that is pasted into Excel 2010. You will need to write a macro to aggregate the data on one tab moving parts of strings to another tab. This is a recursive MACRO and will need to find rows where a certain string is found. Once this row is found the macro will pull the date and name from rows above the entry before continuing the loop.
In the attached file you will find sample data (will change, but the format of the data will not) as well as an example of a literal clean up (not all data, but concept). I've also added comments for guidance.
Here are the text entries to flag:
OT Cancel <24
OT Cancel >24
TAFW No Call/No Show
TAFW Unpaid Unplanned
TAFW FMLA Unpaid
Loop must have protection from timeouts if we are cleaning a long date range. Will need to test the file with multiple raw data examples to ensure it is fully working.
If you can create this, our company will need several cleaners created for different reports. The ideal candidate would also be able to create excel dashboards to present the data as well as excel tools such as staff attendance trackers.