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.
36 freelancers are bidding on average $78 for this job
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
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.
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]