In Progress

Create TimeSheet Report From Excel CSV File

Create timesheet report that uses data from csv file and create reports for each name in the report.

Source will include 15-20 columns of data, not all columns will be used.

Source file will be a csv file imported into Excel and then a customized version of the timesheet is created with all the clock ins and outs on the report. Multpage with multiple names.

See attached sample file with fields needed on the report.

The hours will have to be calculated to show overtime, i.e. hours over 8 and DT hours of 12, but these should be variables that can be changed.

Attached find a sample report. The template should be easy to change in Excel so that when the next batch if data is imported it automatically is imported and formatted.

Skills: Excel, Visual Basic, Visual Basic for Apps

See more: template source file, uses for excel, excel uses, reports in excel, report from excel, DT, customized report excel, template report, excel 2013 version, sample visual basic excel, batch batch excel file, 2013 excel visual basic, batch file name, excel 2013 visual, excel sample file, source file, visual basic excel 2013, create csv file excel vba, excel report csv file, timesheet source, excel 2013 visual basic, create excel csv file, csv file template, sample excel report, excel change csv

About the Employer:
( 254 reviews ) Pasadena, United States

Project ID: #5060320

Awarded to:

mrbrave

Hi...Expert Excel user here....I have completed over 100 projects regarding Excel and VBA on this site...I will provide a VBA based automated process of report developing......Report will be generated just by clicking More

$105 USD in 1 day
(207 Reviews)
6.5

36 freelancers are bidding on average $78 for this job

zExcel

Hi, I can help you with this rather quickly, and you only pay if you're happy with the solution. Looking forward to accepting my bid so I can start on it right away

$55 USD in 1 day
(257 Reviews)
7.6
expertatwork

Hey mazbre,Experts team here. How you want the reports be generated ? Please reply and we like to discuss more. To know our reputation, please visit our profile ***[url removed, login to view]*** Expecting More

$66 USD in 3 days
(182 Reviews)
6.0
javed1705

I am an ACCA , APA and Mcom finance having full command over advance excel You project has caught my attention as i know that this is my favorite topic and i am highly interested with due concern... I am fully More

$64 USD in 3 days
(61 Reviews)
5.8
binaryromel

Hi there, I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, FARZANA PINKY.

$59 USD in 1 day
(87 Reviews)
5.9
dviruki

Hi, I can create the report. I have 12+ years of Excel and VBA experience. Please see 3 layouts of a timesheet report I created for your project at [url removed, login to view]

$50 USD in 1 day
(66 Reviews)
5.4
elMancha

Hello there. I have high Excel and Visual Basic skills with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule. I' More

$59 USD in 3 days
(61 Reviews)
5.4
FIBIN

Hi I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% ac More

$60 USD in 2 days
(54 Reviews)
5.5
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [url removed, login to view] Looking for further discussions in this matter. with than More

$98 USD in 3 days
(42 Reviews)
5.6
eperfections

10+ years experience. 500+ projects completed. EXPERT in CSV maniulation. I can do this easily. Ready to start ASAP.

$150 USD in 3 days
(25 Reviews)
5.0
piyushdpatel

I have 8 yrs of Exp in VBA,VB6,VB.net and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start I will give you robust solution.. if your CSV or Excel Format is Fix then we can Import More

$80 USD in 3 days
(23 Reviews)
5.1
AAATom

Hello! This is one of my first bids on Freelancer, however I have more than 20 years of professional experience as a programmer. I'm skilled in Excel and Excel VBA and I'm confident that I can finish this job wit More

$72 USD in 1 day
(15 Reviews)
4.8
nblsoft

Hello sir, I am very interested to work on your project. I've done similar work before, pleas see my reviews. Looking Forward Nblsoft

$55 USD in 3 days
(5 Reviews)
4.2
nehasinha

Hi I have 10 years experience in Excel Automation. I have worked in few projects earlier through rentacoder/vworker (this company was later taken over by Freelancer last year). I have worked on similar projects wher More

$84 USD in 3 days
(7 Reviews)
4.1
pashute

My easily customized macro, will open a UI, where you can choose with a [browse...] button, the CSV file you wish to upload. It will then load the file into the worksheet and open the Save As... dialog with a suggested More

$48 USD in 1 day
(7 Reviews)
4.0
nmcdorman

Hello, I am trying to make a name for myself so I am willing to work harder and cheaper than anyone else on here. I work with VBA powered Excel reports on a daily basis. Designing an output based on the .csv file will More

$40 USD in 3 days
(2 Reviews)
3.6
vikashgadia

we are excel vba expert this is a very simple project just like piece of cake............................................................................................................................................. More

$66 USD in 3 days
(15 Reviews)
3.8
binarycodersvw

Hi. I have read the description of your project. My name is Andrei. I am a Visual Basic .NET programmer and website developer with 10 years experience. I know you hear things like these a lot but I can show proof. 3 More

$147 USD in 7 days
(4 Reviews)
3.1
ziafar

hello i am expert in Excel and vba. i can help you. can you award me project to perform your request ? regards

$105 USD in 5 days
(7 Reviews)
3.3
NhatAnhIT

Hi victorcab, The first, i have read and understood your requirement. So i ensure with you i can do it for you within totay and give you result as soon as possible. I often do project like your project in my company, More

$50 USD in 1 day
(1 Review)
2.3
derrickpogi

Hello, I am very excited to do this. I will do this in VB so you will have a better user interface. Why you should choose me? 1.) I am very proficient in VB. 2.) I love creating applications to make people's More

$50 USD in 3 days
(2 Reviews)
1.4