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



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.

Beceriler: Veri Girişi, Veri İşleme, Excel, Visual Basic

Daha fazlasını gör: sample data entry test, excel work in company, data entry tools in excel, excel tools, data entry from raw, excel macro row, dashboards excel 2010, range macro excel, excel 2014 macro, excel report macro, excel macro parts, excel change data format, macro report, excel create macro, certain strings, excel find date, create tab excel, macro excel report format, write multiple excel file, raw data report

İşveren Hakkında:
( 8 değerlendirme ) Ocoee, United States

Proje NO: #6845340



Hello, I did many similar projects, I did a somewhat similar project recently www.freelancer.com: https://www.freelancer.com/projects/Data-Entry-Excel/Design-XLS-that-will-format.html You can see how I made it: Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(2 Değerlendirme)