EXCELWhat is the command that I can do to join the sheets?

[bareedon]

We have daily EXCEL report for ten technicians, and we want to create monthly report for each one from those ten technicians. By collecting the data from the daily reports for thirty days, so at the end we will have one report for each technician. What is the command that I can do to join the sheets?

Thankx in advance

 

[arthurbr]

As surely will be pointed out, it is bad practice to make multiple spreadsheets for the same reports.
There is no command available, maybe VBA would do the trick.
If each of your sheets has the same structure you might want to try Pivot Table with multiple consolidation ranges.

Good luck

 

[SkipVought]

Hi,

As Arthur suggested, multiple sheets is a BAD practice.

take a look at PivotTable, AutoFilter and the SubTotal features in the Data menu.

Skip,
[sub]
[red][/red]
[/sub]

 

[djj55]

You could always use VBA to populate the same report then print it for each tech. That way you can have one worksheet for the report and one worksheet for each tech's data. The code would pull the data from each worksheet (for each x in wscollection) putting in logic to skip the report sheet.

Hope this gives you some idea's.
Good Luck,
djj

 

[bareedon]

Thank you all ..

 

[Salut39]

Hi if you still interested I have a possible solution for you. If you use identical daily reports you can combine them into monthly summary and then pick up an individual from that sheet. You need to creat three more sheets, call them "summary", "start" and "End". Keep summary with the same format as your daily sheets but replace data with the formula:
=SUM(Start:End!A1) copy formula to all cells and put your daily sheets between "Start" and "End" sheets. You can add sheets by dragging them after "start" and before "end" creating weekly, monthly reports and so on.

Yuri