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.
15 freelancers are bidding on average $39 for this job
Masters Degree in Software Engineering with 20 years of teaching experience. Specialty in MS Excel, Word, C/C++ programming. Taught courses like MS Office, programming with C/C++, Object Oriented Programming with C++.
we are a team made up of highly skilled [url removed, login to view] have been on such projects for quiet a number of [url removed, login to view] can assure you of the best quality job at the fastest [url removed, login to view] us and you will never regret.
I have 4 years experience in VBA Macro, I have already worked with Whirlpool USA with an automated analytic tool and I am currently working on big energy project from Poland.