Excel Consolidate timesheet Data into 1 spreadsheet
$30-250 AUD
货到付款
We have 26 x MS Excel 2007 timesheets. Each timesheets is for one project, so we have 26 projects / timesheets to process. Each project timesheet has up to 12 employes working on it. The data for each employee goes back approx 1 year. Their time sheet consists of the employee initials, date, start time, finish time, phase & task. The individual employee data from those 26 timesheets need to be copied and pasted into a new single timesheet as a long columns of data. The process is to have the new Excel master timesheet open, then open the old timesheet and copy and paste a block of employee time sheet data into the new master timesheet. Add the name of the project code and the employee initials to the new data using drag and fill.
Attached is a copy of the NEW MASTER timesheet file already set up. You can see an example how the data is to look.
Attached is a copy of an old project timesheet data file which shows the data to be copied. You can see an where the data is to be copied from. Note each employees timesheet is a seperate worktab and each weeks' data is a new block across the top of the worksheet.
The job is very simple, just a bit repetitious.
Good luck in your bid!
项目ID: #2432025
关于项目
授予:
有15名威客正在参与此工作的竞标,均价$55/小时
Hi, Ready to start your work. We have a team. We will complete your work quickly. Eagerly awaiting for your project approval. Thanks, Jennifer.
Hi I am interested in this project. Ready to start immediately. I have understood the requirement. Please check you private message box.
Dear Concern, We are IDOCZ, We have an team. We understood your requirements & we will be suitable for this projects. All are Eager to work for your utmost satisfaction. Thanks Jessie. IDOCZ