已关闭

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

查看更多: 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, sample attendance, excel attendance, cleaning excel data, show attendance report, moving excel

About the Employer:
( 0 reviews ) Somanya, Ghana

项目ID: #6845400

15名威客为此工作的平均竞标价是$39

Teloquence

Hello, I am top excel developer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your refere 更多

$30 USD 在0天内
(251条评论)
7.1
zExcel

A proposal has not yet been provided

$50USD 在1天里
(128条评论)
6.7
koolsidz

Hello :) I am an VB / Excel Expert. If you see my reviews by navigating to this link [url removed, login to view] then you will notice that I have not 更多

$25USD 在1天里
(136条评论)
6.2
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou 更多

$28 USD 在0天内
(87条评论)
6.1
vsprybhanu

Hi, Experienced VBA, VB6 and VB.Net Programmer. Expertise in Data Entry, Data Processing, Excel and Programming. Read and understood your project description. I've excellent knowledge of moving data arou 更多

$30USD 在1天里
(30条评论)
4.1
momo2619

Hi, I am happy to work on your project to create the macro to do the work you are requesting. There is only one thing that there is no attachment in the project. But I'm comfortable to discuss that and you can send t 更多

$61USD 在1天里
(9条评论)
3.2
sergpooh

I'm not see the attached file. Please, send me file .

$25USD 在1天里
(1条评论)
1.8
satori12345

Experience: I am a Dallas based Financial Analyst with over 20 year experience in Excel and Visual Basic programming. I have created a significant number of automated Excel forms with buttons and macros that perform a 更多

$55 USD 在3天内
(1条评论)
0.4
tandonshailendra

About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group 更多

$50 USD 在3天内
(1条评论)
0.0
jeffreylee000

I am an excellent excel programmer and believe I will be able to make you a macro that can do all that you require. I also am able to make dashboards.

$25USD 在1天里
(0条评论)
0.0
ProfAhmad

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++.

$80 USD 在2天内
(0条评论)
0.0
xBlaster

A proposal has not yet been provided

$55 USD 在3天内
(0条评论)
0.0
opokuchristian

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.

$25USD 在1天里
(0条评论)
0.0
clearatul0

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.

$25 USD 在3天内
(0条评论)
0.0
rajan1980ntcse

A proposal has not yet been provided

$25USD 在1天里
(0条评论)
0.0
camzjd

Good Day! I am here to provide you quality service and ensure the effectivity of the project. I am a detail-oriented type of a person and always motivated to get the job done fast with high quality. Please contact me 更多

$25 USD 在0天内
(0条评论)
0.0