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.
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
Hi,
I have gone through your project requirement in detail and feel comfortable in taking up your project. I have worked on number of Excel projects involving VBA macros and thus can help you out in providing you the solution.
Waiting for your response to talk further in detail and plan out work. Thanks.
sir i have 8 year experience of software and web development
i can do your work faster a with nest quality than others at lowest cost
you can check my port folio and previous projects
i can star working on your project just now
so please allow me for PM
[The administrator removed this message for containing contact details which breaches our Terms and Conditions - Section 13:Communication With Other Users.]
Hi
I have a quick automated solution for such cases. I can easily get this done for you with 100% accuracy and column flexibiltiy.
Btw, I dont see attachments with the project. Please share the same.
Hello, sir and mrs
I am here to discuss about this work
I already experience in Microsoft Office like power point , excel and word.
More importantly i can do this job earlier with my hardworking and effort
I would like to thank you for this opportunity and your time in reviewing this proposal. I hereby do understand the needs of the project and since this is my area of specialization, i assure you that the work will be completed within the given period of time. The project and its techniques will be used according to the specification of the clients in order to satisfy the needs of the clients.
I do appreciate the contract and I am ready for any contact from the clients concerning the contract.