Hi,
I am trying to figure out an easy way to take all of my Daily Sheet’s for a month and combine them into 1 “Master Summary” file. The main focus at this time is the information in the “Work Summary” section in the middle of the page (see attached picture), where we would like to combine the “Ref. No” and “Item No.” from each day to give us the total quantity from the month.
Excel 2007
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
I know this can be done by copy and paste and filters but with several projects going on at a time, I do not have the time to go through every one for a quick check. Thank you in advance for any assistance on this project.
I am trying to figure out an easy way to take all of my Daily Sheet’s for a month and combine them into 1 “Master Summary” file. The main focus at this time is the information in the “Work Summary” section in the middle of the page (see attached picture), where we would like to combine the “Ref. No” and “Item No.” from each day to give us the total quantity from the month.
Excel 2007
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Job Name: | 2016 Resurfacing Project | Report No.: | Date: | 7/9/2016 | Day: | Sat | ||||||||
2 | |||||||||||||||
3 | Temperature: | 85 | High | Contract days | Ground conditions | Air conditions | |||||||||
4 | 72 | Low | Work day | x | Damp | Clear | x | ||||||||
5 | Non-work day | Dry | x | Showers | |||||||||||
6 | Start time: | 7:00 | AM/PM | Work days to date | Frozen | Storms | |||||||||
7 | Stop time: | 5:00 | AM/PM | Saturated | Snow | ||||||||||
8 | No work completed: | Cloudy | x | ||||||||||||
9 | |||||||||||||||
10 | Work Summary: | ||||||||||||||
11 | Ref. No. | Item No. | Description | Location | Qty. | ||||||||||
12 | Sta. | - - - | Sta. | ||||||||||||
13 | WCEO | 253 | Pavement Repair | CR-22 | - - - | 601.78 SY | |||||||||
14 | WCEO | 253 | Pavement Repair | CR-126 | - - - | 272.28 SY | |||||||||
15 | - - - | ||||||||||||||
16 | - - - | ||||||||||||||
17 | - - - | ||||||||||||||
18 | - - - | ||||||||||||||
19 | - - - | ||||||||||||||
20 | - - - | ||||||||||||||
21 | - - - | ||||||||||||||
22 | - - - | ||||||||||||||
23 | - - - | ||||||||||||||
24 | - - - | ||||||||||||||
25 | - - - | ||||||||||||||
26 | |||||||||||||||
27 | Materials received this date: | ||||||||||||||
28 | Type of Material | Material Supplier | Qty. | ||||||||||||
29 | |||||||||||||||
30 | |||||||||||||||
31 | |||||||||||||||
32 | |||||||||||||||
33 | |||||||||||||||
34 | |||||||||||||||
35 | |||||||||||||||
36 | Diary of Work: | ||||||||||||||
37 | Completed Full Depth Repair on CR-22 | ||||||||||||||
38 | |||||||||||||||
39 | Moved equipment to Red Lion - Five Points. | ||||||||||||||
40 | |||||||||||||||
41 | Began Full Depth Repair on Red Lion - Five Points. | ||||||||||||||
42 | |||||||||||||||
43 | |||||||||||||||
44 | |||||||||||||||
45 | |||||||||||||||
46 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
I know this can be done by copy and paste and filters but with several projects going on at a time, I do not have the time to go through every one for a quick check. Thank you in advance for any assistance on this project.