Visual Basic, Data matching

Closed

Every two weeks I have to pull an attendance report. In this report we have the employees work date and work time. Please look at attendance 8-19-9-9 excel file.

With this file we open the second excel file. payroll9-8-13. We go to the data sheet and enter how many hours each person worked under which position they are assigned to. The three most important positions is Server Busser and Kitchen. We enter their hours and excel distributes the tips among our staff.

The need from the project is the eliminate the time we spend entering these numbers. So on attendance excel under employee named David, if it say he worked 3 hours 34 minutes lunch shift on 09/02/2013 then on payroll excel under data sheet it should put 3.6 (rounding up) for the shift David worked under that day.

I will give more details to explain the process.

Skills: PHP, Software Architecture, Visual Basic

See more: data matching project, payroll process in excel sheet, payroll position, david data, payroll process in excel, payroll how to, how to payroll, Visual Basic Excel, payroll process, excel visual basic, php work attendance, staff payroll excel work, sheet excel visual basic, 2013 excel visual basic, excel 2013 visual, work attendance excel, visual basic 2013, matching excel file, visual basic excel 2013, payroll attendance, matching excel, attendance time excel, excel 2013 visual basic, excel data matching, employee data php

Project ID: #4915783

25 freelancers are bidding on average $156 for this job

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$257 USD in 7 days
(237 Reviews)
7.8
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$463 USD in 5 days
(439 Reviews)
7.3
weng0000

Hi! Please check your private message. Thank you.

$150 USD in 3 days
(755 Reviews)
6.9
cheapexcell

Can be done. Ready to start

$129 USD in 3 days
(119 Reviews)
6.0
appwiz

Good day, this seems reasonably straightforward... please see my private message for full bid details.

$155 USD in 3 days
(46 Reviews)
5.6
expertcoder1vw

I can develop a database for you to automatically do this. It will import the 2 excel files, and generate the new report with the calculated hrs, producing a new 3rd Excel file with the totals calculated correctly. More

$190 USD in 3 days
(33 Reviews)
5.3
ZeusMan

Looking forward to working with you...

$131 USD in 3 days
(32 Reviews)
5.1
northwolves

Expert of Excel & VBA,,I'm ready to start.

$112 USD in 3 days
(35 Reviews)
4.7
russel02cuet

Hi, Thanks for clear project description You can consider this task done professionally by me. I am expert vb.net coder. I can process these excel file by application. Thanks -Rus

$150 USD in 3 days
(52 Reviews)
4.4
ExactSystems

Please see a more robust solution on PMB. regards

$222 USD in 5 days
(4 Reviews)
4.1
bmartynvw

Please read PM

$195 USD in 9 days
(8 Reviews)
3.9
MDavidCrompton

I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback. I am UK based, a native English spe More

$150 USD in 3 days
(10 Reviews)
3.8
paris2785

VB, VBA and Databases expert for over a decade. Master in Information Systems.

$88 USD in 5 days
(3 Reviews)
3.4
expertatwork

Hi nxaydinel, I believe you are using Ms Excel... which OS are you using - MAC or WINDOWS ? We write Excel macros only for all WINDOWS operating systems

$88 USD in 6 days
(8 Reviews)
2.9
singharun7

i will do your task................. plz provide add details................

$100 USD in 7 days
(2 Reviews)
2.3
devduttc22

HI< I am expert lets start. you will be happy with my work. Thanks

$110 USD in 5 days
(1 Review)
1.8
jgsini

This can be done as per your requirement. Thanking you.

$155 USD in 7 days
(1 Review)
1.4
onlyLekha

i will provide u a simple VB6.0 Application through which you can do all this very simply and get reports on that basis...

$150 USD in 3 days
(1 Review)
0.1
ganiweecom

I have 5 years experience in VB.NET,C#,DevExpress,MSSql. I am qualified for this project.

$55 USD in 5 days
(0 Reviews)
0.0
obak

I think you need a complete payroll system for your windows environment. For $250 payment i can develop an windows app using vb6 and ms access database for you. I already worked on this kind of software. If you hire me More

$244 USD in 7 days
(0 Reviews)
0.0