Copy Data from Multiple weekly Sheet to Monthly sheet and filter the data

**santhoshjoseph** · 11-05-2012, 07:14 AM

Hi

I am new to this forum and I found it as a great help for beginners as well as for them who need some instant help.
I am struggling to resolve a problem since one week and was doing lot of search, then I found this forum.

I have a workbook with multiple sheets (4 to 5 sheets) each contains a weekly data for different users, the work they did, status of the work and hours spend for each work. In the monthly sheet I should get data per user, for each project Id, for each phase, how much actual hours he put. Different users might work on same project, so this should be captured separately. If user A works on project P00010, testing phase on week one and week two, I need the total of hours he spend for the entire month.

This is very urgent, could anyone please help me. A sample sheet is attached.

Thanks for your help in advance

Santosh

**arlu1201** · 11-06-2012, 05:27 AM

So you need a macro that will consolidate the data into 1 sheet, right? Anything else to be added to the macro?

**santhoshjoseph** · 11-06-2012, 05:58 AM

Yes. but after consolidation, the macro has to do some filter so that i can see a report per user, for each project Id, for each phase, how much actual hours he put.

**arlu1201** · 11-06-2012, 06:02 AM

You mean have one sheet for the consolidation and then separate sheets per user?

You can even create a userform and select the filters from there, which will appear in one output sheet. If you change the filter, the data in the output sheet is cleared and new data shown.

**santhoshjoseph** · 11-06-2012, 07:07 AM

Its not how I wanted. I am thinking of a sheet, with data from all the weekly sheets, so that I can have all the data on a single sheet. then we can create a monthly sheet from that. I have attached a workbook with the rough sheet and monthly sheet.
In the monthly sheet the rows should not duplicate. that is if the same user, with same project, has two rows with same phase, then the actual hours can be sum up to show in one row.

please find the attached and thanks for your help.