Excel Macros to autofill data in timesheet spreadsheet

I am a newbie to Excel macros and have a question regarding using macros To autofill spreadsheets.

Each week we collect data from time sheets that are e-mailed from foremen out in the field. These sheets include names, dates, job numbers, and hours worked. (Please see attached examples from two foremen.) We copy and paste this data into a spreadsheet, sort the data, and then enter it into our software system for Payroll.

Right now we are opening a workbook, selecting and copying data from an individual time sheet, switching to the spreadsheet to paste it, and then switching back again to the workbook to move on to the next time sheet, etc..

I would like to find a way to either collect the data I want from the entire workbook at one time to paste in, or at the very least, to record a macro that will copy the data I've selected on a sheet, paste it onto the spreadsheet, move down a row ready for the next batch of data, and return me to the open worksheet (to cell A13, for example), so that I do not have to manually switch back and forth between the time sheets and the spreadsheet. (So that I click on a worksheet tab, select data, macro, click on next tab, select data, macro, etc., without having to switch to the spreadsheet until I'm done collecting the data from the entire workbook.)

I have come close to this with some minor macro adjustments, but do not understand about macro writing, so have not gotten a completely satisfactory setup yet.

I have attached the files that I am working with. I would so appreciate any help as this would take HOURS off each week's work.

Hi

Put your 4 files above into the same directory. Then rename the file 00...semi final to be something like 200...... (Just make sure it doesn't start with 00).

In the workbook 00location_sheet_example.xls, insert a general module and put in the code

Please Login or Register  to view this content.

Run it and see how it goes.

rylo