Do some Excel Work

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

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.

Εισαγωγή Δεδομένων Επεξεργασία Δεδομένων Excel Visual Basic

Ταυτότητα Εργασίας: #6845340

Σχετικά με την εργασία