HALP! Macro for copying rows from several workbooks into a seperate worksheet troubles...

Hello,

Hope you are fine.

I need some help designing a macro that will copy specific rows from several workbooks into one worksheet. More specifically, I'm trying to import data from several staff member's Excel timesheets into a seperate spreadsheet(let's call it the "Import spreadsheet"), so as to combine the data making it easier to analyse.

I'm sure this is doable...but my lack of VBA knowledge means it's just taking me ages to figure out :-( I am a damsel in distress!!

So, I can save all the timesheets into one folder so the macro only has to look in one place. The macro needs to then do the following:
- Open each timesheet in the folder of saved timesheets
- The default entry in column B of a timesheet is the text "Code"; when logging time spent on a project, staff members need to enter a five-digit timecode reference into this column instead. If there is a five-digit timecode in any row, do the following:
- copy the staff member's name from cell C5 of the timesheet into the next blank row of column B of the Import spreadsheet
- copy the timecode from column B of the timesheet into into column C of the Import spreadsheet
- copy the description from column D of the timesheet into column D of the Import spreadsheet
- total time spent per month is summarised in columns on the timesheets (e.g. column F is the column for April's time, column G is the column for May's time). The Import spreadsheet will have the months laid out across the top in one row in a similar style. I'd like the macro to copy and paste hours spent per project, referencing the month name from the Import spreadsheet, into each month's column.
- do this for each row in a timesheet with a five-digit number in row B
- and do this for each timesheet saved in a folder (folder name will change on a weekly basis)

Any help greatly appreciated...

Thank you

Isabel

Thanks so much for the prompt reply mehmetcik! Very kind of you.

I think we're part way there. I've made an example Timesheet and an example Summary sheet to better demonstrate what I'd like the macro to be able to do.

All timesheets are in the format of the "Timesheet.xls"; with the staff's name in one cell, and a list of codes and descriptions in seperate columns, and the total number of hours spent on each activity each month seperated by columns.
I'd like the macro to copy and paste name, code, project description, and total hour spent per month into a row on the Summary sheet (a seperate row for each uniwue five-digit code).

I hope this helps describe it better? Sorry, I find it quite difficult to explain this type of thing.

Thanks again,

Isabel

Hi,
Thanks again.
That made my Excel crash. And it produced an Excel sheet entitled "Summary" which is just a copy of someone's timesheet.
Is there any way I can funnel the macro into a button instead of a file?

Thanks
Isabel