VBa code to subtotal by week ending date and monthly total

rjrsn

New Member
Joined
Feb 16, 2005
Messages
25
Hello, Help needed in a report. The data is listed in columns as indicated below. I need to generate a report showing an end of week subtotal ending on each Thursday at close of business. The fields that I need to generate by VBA are listed below the data. I need VBA to make each column and compile all data listed from Friday to the following Thursday and would be listed as week ending. The second week I need the same calculation based only on the second week, and then the 3rd and the 4th and/or 5th if it occurs. Once the weekly totals are calculated it goes into the weekly rows. Each week that ends in Thursday will have it's own total with the final row giving the monthly total. Can someone help me with the particular code to do this? Thanks for the anticipated help and feel free to ask any questions and I am able to privately email the particular document as necessary. Bob


LOCATION DATE "TRACE ID
NUMBER
(MMYY-NUMBER)" "BEGIN
TIME
(PULL DOWN)" "END
TIME
(PULL DOWN)" HOURS OFFICER "HMV
SPEED" HMV OTHER NHMV PARKING VW SPEED VW OTHER ARRESTS CRASHES CARS TOWED TOTAL
these are the fields where data is entered:

Subtotal lines are displayed as indicated below:

Week Ending HOURS "HMV
SPEED" HMV OTHER NHMV PARKING VW SPEED VW OTHER ARRESTS CRASHES CARS TOWED TOTAL
Thursday, November 9, 2017
Thursday, November 16, 2017
Thursday, November 23, 2017
Thursday, November 30, 2017
Totals for Month of (pulled from the week ending)
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
can you put it in a spreadsheet layout as it is unclear ie is location .. date... traceidnumber...begintime...endtime...hoursofficer....hmvspeed....etc etc
 
Upvote 0
Hello, Help needed in a report. The data is listed in columns as indicated below. I need to generate a report showing an end of week subtotal ending on each Thursday at close of business. The fields that I need to generate by VBA are listed below the data. I need VBA to make each column and compile all data listed from Friday to the following Thursday and would be listed as week ending. The second week I need the same calculation based only on the second week, and then the 3rd and the 4th and/or 5th if it occurs. Once the weekly totals are calculated it goes into the weekly rows. Each week that ends in Thursday will have it's own total with the final row giving the monthly total. Can someone help me with the particular code to do this? Thanks for the anticipated help and feel free to ask any questions and I am able to privately email the particular document as necessary. Bob


LOCATION DATE "TRACE ID
NUMBER
(MMYY-NUMBER)" "BEGIN
TIME
(PULL DOWN)" "END
TIME
(PULL DOWN)" HOURS OFFICER "HMV
SPEED" HMV OTHER NHMV PARKING VW SPEED VW OTHER ARRESTS CRASHES CARS TOWED TOTAL
these are the fields where data is entered:

Subtotal lines are displayed as indicated below:

Week Ending HOURS "HMV
SPEED" HMV OTHER NHMV PARKING VW SPEED VW OTHER ARRESTS CRASHES CARS TOWED TOTAL
Thursday, November 9, 2017
Thursday, November 16, 2017
Thursday, November 23, 2017
Thursday, November 30, 2017
Totals for Month of (pulled from the week ending)

Came up with a simpler way I think. I have repeating data in rows 1 through 6 consisting of letterhead and a jpg picture.
A7-LOCATION
B7-DATE
C7-"TRACE ID NUMBER (MMYY-NUMBER)"
D7- "BEGIN TIME (PULL DOWN)"
E7-"END TIME (PULL DOWN)"
F7-HOURS(calculated field)
G7-OFFICER
H7-"HMV SPEED"
I7-HMV OTHER
J7-NHMV
K7-PARKING
L7-VW SPEED
M7-VW OTHER
N7-ARRESTS
O7-CRASHES
P7-CARS TOWED
Q7-TOTAL --Calculated formula SUM
Data is entered one event per row continuing down the worksheet.

In cells AB7 THROUGH AT13 is a range of cells showing weekly totals. 1st step of macro is to copy this range and insert it into cell A7 and also move the existing data down to row 14. So it should be insert copied data into the row and not erase anything. I say this because I don't want existing data overwritten just moved down.
Ok we have the new range inserted and all data is intact. Once this range is copied and inserted, cell A8 requires a date. I would like the macro to search the data in column B, starting at row 14 for the first Friday in the month of the dates in column B. example: date is shown as 11/14/2017. The macro reads the date as November and puts the date of the first friday in the month of November into cell A8.The macro should use this date to do a search of column B and search for any date from that Friday back to the previous Saturday Friday - 6 . Then search for all of these dates and sort chronologically in column B.
The macro should do a subtotal (weekly totals) on columns C, (this column has multiple numbers in it and I need a count of all non-blank cells during this time), F, and H through P, with a total of this row in column Q of the inserted range in row 8. Now the Macro inserts a blank line after the first week of data in the data.
the next Row 9, the macro would repeat itself but with the next week and data put into for the second weeks subtotals and again insert a blank line at the end of the second weeks data.
I couldn't upload a picture of what Im talking about, sorry. I hope this isn't too big of a job but I'm at a loss on how to make this work. It is for a traffic unit in a police department where I am a stat keeper. Any questions please ask and I hope I can be helped. thanks in advance.
 
Upvote 0
[TABLE="width: 1172"]
<colgroup><col><col><col span="7"><col><col span="8"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]col Q[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD="align: right"]01/10/2017[/TD]
[TD]1017-1001[/TD]
[TD="align: right"]10:35[/TD]
[TD="align: right"]13:59[/TD]
[TD="align: right"]03:24[/TD]
[TD]Dibble[/TD]
[TD="align: right"]73[/TD]
[TD]other1[/TD]
[TD]something1[/TD]
[TD]no[/TD]
[TD="align: right"]66[/TD]
[TD]vwother1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD="align: right"]01/10/2017[/TD]
[TD]1017-1002[/TD]
[TD="align: right"]06:14[/TD]
[TD="align: right"]09:44[/TD]
[TD="align: right"]03:30[/TD]
[TD]Jones[/TD]
[TD="align: right"]84[/TD]
[TD]other2[/TD]
[TD]something2[/TD]
[TD]no[/TD]
[TD="align: right"]64[/TD]
[TD]vwother2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]is this the data[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]put in any altrerations[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]say what the total column actually totals[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]then I will add weekly and monthly totals[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Hours in column is calculated and formatted as: [h]:mm;@ in the choices. I must ask that this would be the proper formatting for the hours to calculate and post such as 47:45 which would be 47 hours and 45 minutes. Just to make sure...

All data from H7 over to the right are whole numbers. They are listing the total number of violations and not the actual offense.
Q7 sums from H over to P and is formatted as a whole number.

Thanks Bob
 
Upvote 0
[TABLE="width: 1172"]
<colgroup><col><col><col span="7"><col><col span="8"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]col Q[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]29/09/2017[/TD]
[TD]0917-1001[/TD]
[TD]04:35[/TD]
[TD]06:59[/TD]
[TD]02:24[/TD]
[TD]name1[/TD]
[TD]73[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]9[/TD]
[TD]11[/TD]
[TD]13[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]136[/TD]
[TD]row 7[/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]30/09/2017[/TD]
[TD]0917-1002[/TD]
[TD]04:54[/TD]
[TD]07:24[/TD]
[TD]02:30[/TD]
[TD]name2[/TD]
[TD]74[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]11[/TD]
[TD]13[/TD]
[TD]15[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]154[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]01/10/2017[/TD]
[TD]1017-1003[/TD]
[TD]05:13[/TD]
[TD]07:49[/TD]
[TD]02:36[/TD]
[TD]name3[/TD]
[TD]75[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD]13[/TD]
[TD]15[/TD]
[TD]17[/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]12[/TD]
[TD]172[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]02/10/2017[/TD]
[TD]1017-1004[/TD]
[TD]05:32[/TD]
[TD]08:14[/TD]
[TD]02:42[/TD]
[TD]name4[/TD]
[TD]76[/TD]
[TD]14[/TD]
[TD]13[/TD]
[TD]15[/TD]
[TD]17[/TD]
[TD]19[/TD]
[TD]10[/TD]
[TD]12[/TD]
[TD]14[/TD]
[TD]190[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]03/10/2017[/TD]
[TD]1017-1005[/TD]
[TD]05:51[/TD]
[TD]08:39[/TD]
[TD]02:48[/TD]
[TD]name5[/TD]
[TD]77[/TD]
[TD]17[/TD]
[TD]15[/TD]
[TD]17[/TD]
[TD]19[/TD]
[TD]21[/TD]
[TD]12[/TD]
[TD]14[/TD]
[TD]16[/TD]
[TD]208[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]04/10/2017[/TD]
[TD]1017-1006[/TD]
[TD]06:10[/TD]
[TD]09:04[/TD]
[TD]02:54[/TD]
[TD]name6[/TD]
[TD]78[/TD]
[TD]20[/TD]
[TD]17[/TD]
[TD]19[/TD]
[TD]21[/TD]
[TD]23[/TD]
[TD]14[/TD]
[TD]16[/TD]
[TD]18[/TD]
[TD]226[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]05/10/2017[/TD]
[TD]1017-1007[/TD]
[TD]06:29[/TD]
[TD]09:29[/TD]
[TD]03:00[/TD]
[TD]name7[/TD]
[TD]79[/TD]
[TD]23[/TD]
[TD]19[/TD]
[TD]21[/TD]
[TD]23[/TD]
[TD]25[/TD]
[TD]16[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]244[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]06/10/2017[/TD]
[TD]1017-1008[/TD]
[TD]06:48[/TD]
[TD]09:54[/TD]
[TD]03:06[/TD]
[TD]name8[/TD]
[TD]80[/TD]
[TD]26[/TD]
[TD]21[/TD]
[TD]23[/TD]
[TD]25[/TD]
[TD]27[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]22[/TD]
[TD]262[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]07/10/2017[/TD]
[TD]1017-1009[/TD]
[TD]07:07[/TD]
[TD]10:19[/TD]
[TD]03:12[/TD]
[TD]name1[/TD]
[TD]81[/TD]
[TD]29[/TD]
[TD]23[/TD]
[TD]25[/TD]
[TD]27[/TD]
[TD]29[/TD]
[TD]20[/TD]
[TD]22[/TD]
[TD]24[/TD]
[TD]280[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]08/10/2017[/TD]
[TD]1017-1010[/TD]
[TD]07:26[/TD]
[TD]10:44[/TD]
[TD]03:18[/TD]
[TD]name2[/TD]
[TD]82[/TD]
[TD]32[/TD]
[TD]25[/TD]
[TD]27[/TD]
[TD]29[/TD]
[TD]31[/TD]
[TD]22[/TD]
[TD]24[/TD]
[TD]26[/TD]
[TD]298[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]09/10/2017[/TD]
[TD]1017-1011[/TD]
[TD]07:45[/TD]
[TD]11:09[/TD]
[TD]03:24[/TD]
[TD]name3[/TD]
[TD]83[/TD]
[TD]35[/TD]
[TD]27[/TD]
[TD]29[/TD]
[TD]31[/TD]
[TD]33[/TD]
[TD]24[/TD]
[TD]26[/TD]
[TD]28[/TD]
[TD]316[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]10/10/2017[/TD]
[TD]1017-1012[/TD]
[TD]08:04[/TD]
[TD]11:34[/TD]
[TD]03:30[/TD]
[TD]name4[/TD]
[TD]84[/TD]
[TD]38[/TD]
[TD]29[/TD]
[TD]31[/TD]
[TD]33[/TD]
[TD]35[/TD]
[TD]26[/TD]
[TD]28[/TD]
[TD]30[/TD]
[TD]334[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]11/10/2017[/TD]
[TD]1017-1013[/TD]
[TD]08:23[/TD]
[TD]11:59[/TD]
[TD]03:36[/TD]
[TD]name5[/TD]
[TD]85[/TD]
[TD]41[/TD]
[TD]31[/TD]
[TD]33[/TD]
[TD]35[/TD]
[TD]37[/TD]
[TD]28[/TD]
[TD]30[/TD]
[TD]32[/TD]
[TD]352[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]12/10/2017[/TD]
[TD]1017-1014[/TD]
[TD]08:42[/TD]
[TD]12:24[/TD]
[TD]03:42[/TD]
[TD]name6[/TD]
[TD]86[/TD]
[TD]44[/TD]
[TD]33[/TD]
[TD]35[/TD]
[TD]37[/TD]
[TD]39[/TD]
[TD]30[/TD]
[TD]32[/TD]
[TD]34[/TD]
[TD]370[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]13/10/2017[/TD]
[TD]1017-1015[/TD]
[TD]09:01[/TD]
[TD]12:49[/TD]
[TD]03:48[/TD]
[TD]name7[/TD]
[TD]87[/TD]
[TD]47[/TD]
[TD]35[/TD]
[TD]37[/TD]
[TD]39[/TD]
[TD]41[/TD]
[TD]32[/TD]
[TD]34[/TD]
[TD]36[/TD]
[TD]388[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]14/10/2017[/TD]
[TD]1017-1016[/TD]
[TD]09:20[/TD]
[TD]13:14[/TD]
[TD]03:54[/TD]
[TD]name8[/TD]
[TD]88[/TD]
[TD]50[/TD]
[TD]37[/TD]
[TD]39[/TD]
[TD]41[/TD]
[TD]43[/TD]
[TD]34[/TD]
[TD]36[/TD]
[TD]38[/TD]
[TD]406[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]15/10/2017[/TD]
[TD]1017-1017[/TD]
[TD]09:39[/TD]
[TD]13:39[/TD]
[TD]04:00[/TD]
[TD]name1[/TD]
[TD]89[/TD]
[TD]53[/TD]
[TD]39[/TD]
[TD]41[/TD]
[TD]43[/TD]
[TD]45[/TD]
[TD]36[/TD]
[TD]38[/TD]
[TD]40[/TD]
[TD]424[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]16/10/2017[/TD]
[TD]1017-1018[/TD]
[TD]09:58[/TD]
[TD]14:04[/TD]
[TD]04:06[/TD]
[TD]name2[/TD]
[TD]90[/TD]
[TD]56[/TD]
[TD]41[/TD]
[TD]43[/TD]
[TD]45[/TD]
[TD]47[/TD]
[TD]38[/TD]
[TD]40[/TD]
[TD]42[/TD]
[TD]442[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]17/10/2017[/TD]
[TD]1017-1019[/TD]
[TD]10:17[/TD]
[TD]14:29[/TD]
[TD]04:12[/TD]
[TD]name3[/TD]
[TD]91[/TD]
[TD]59[/TD]
[TD]43[/TD]
[TD]45[/TD]
[TD]47[/TD]
[TD]49[/TD]
[TD]40[/TD]
[TD]42[/TD]
[TD]44[/TD]
[TD]460[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]18/10/2017[/TD]
[TD]1017-1020[/TD]
[TD]10:36[/TD]
[TD]14:54[/TD]
[TD]04:18[/TD]
[TD]name4[/TD]
[TD]92[/TD]
[TD]62[/TD]
[TD]45[/TD]
[TD]47[/TD]
[TD]49[/TD]
[TD]51[/TD]
[TD]42[/TD]
[TD]44[/TD]
[TD]46[/TD]
[TD]478[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]19/10/2017[/TD]
[TD]1017-1021[/TD]
[TD]10:55[/TD]
[TD]15:19[/TD]
[TD]04:24[/TD]
[TD]name5[/TD]
[TD]93[/TD]
[TD]65[/TD]
[TD]47[/TD]
[TD]49[/TD]
[TD]51[/TD]
[TD]53[/TD]
[TD]44[/TD]
[TD]46[/TD]
[TD]48[/TD]
[TD]496[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]20/10/2017[/TD]
[TD]1017-1022[/TD]
[TD]11:14[/TD]
[TD]15:44[/TD]
[TD]04:30[/TD]
[TD]name6[/TD]
[TD]94[/TD]
[TD]68[/TD]
[TD]49[/TD]
[TD]51[/TD]
[TD]53[/TD]
[TD]55[/TD]
[TD]46[/TD]
[TD]48[/TD]
[TD]50[/TD]
[TD]514[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]21/10/2017[/TD]
[TD]1017-1023[/TD]
[TD]11:33[/TD]
[TD]16:09[/TD]
[TD]04:36[/TD]
[TD]name7[/TD]
[TD]95[/TD]
[TD]71[/TD]
[TD]51[/TD]
[TD]53[/TD]
[TD]55[/TD]
[TD]57[/TD]
[TD]48[/TD]
[TD]50[/TD]
[TD]52[/TD]
[TD]532[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]22/10/2017[/TD]
[TD]1017-1024[/TD]
[TD]11:52[/TD]
[TD]16:34[/TD]
[TD]04:42[/TD]
[TD]name8[/TD]
[TD]96[/TD]
[TD]74[/TD]
[TD]53[/TD]
[TD]55[/TD]
[TD]57[/TD]
[TD]59[/TD]
[TD]50[/TD]
[TD]52[/TD]
[TD]54[/TD]
[TD]550[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]23/10/2017[/TD]
[TD]1017-1025[/TD]
[TD]12:11[/TD]
[TD]16:59[/TD]
[TD]04:48[/TD]
[TD]name1[/TD]
[TD]97[/TD]
[TD]77[/TD]
[TD]55[/TD]
[TD]57[/TD]
[TD]59[/TD]
[TD]61[/TD]
[TD]52[/TD]
[TD]54[/TD]
[TD]56[/TD]
[TD]568[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]24/10/2017[/TD]
[TD]1017-1026[/TD]
[TD]12:30[/TD]
[TD]17:24[/TD]
[TD]04:54[/TD]
[TD]name2[/TD]
[TD]98[/TD]
[TD]80[/TD]
[TD]57[/TD]
[TD]59[/TD]
[TD]61[/TD]
[TD]63[/TD]
[TD]54[/TD]
[TD]56[/TD]
[TD]58[/TD]
[TD]586[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]25/10/2017[/TD]
[TD]1017-1027[/TD]
[TD]12:49[/TD]
[TD]17:49[/TD]
[TD]05:00[/TD]
[TD]name3[/TD]
[TD]99[/TD]
[TD]83[/TD]
[TD]59[/TD]
[TD]61[/TD]
[TD]63[/TD]
[TD]65[/TD]
[TD]56[/TD]
[TD]58[/TD]
[TD]60[/TD]
[TD]604[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]26/10/2017[/TD]
[TD]1017-1028[/TD]
[TD]13:08[/TD]
[TD]18:14[/TD]
[TD]05:06[/TD]
[TD]name4[/TD]
[TD]100[/TD]
[TD]86[/TD]
[TD]61[/TD]
[TD]63[/TD]
[TD]65[/TD]
[TD]67[/TD]
[TD]58[/TD]
[TD]60[/TD]
[TD]62[/TD]
[TD]622[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]27/10/2017[/TD]
[TD]1017-1029[/TD]
[TD]13:27[/TD]
[TD]18:39[/TD]
[TD]05:12[/TD]
[TD]name5[/TD]
[TD]101[/TD]
[TD]89[/TD]
[TD]63[/TD]
[TD]65[/TD]
[TD]67[/TD]
[TD]69[/TD]
[TD]60[/TD]
[TD]62[/TD]
[TD]64[/TD]
[TD]640[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]28/10/2017[/TD]
[TD]1017-1030[/TD]
[TD]13:46[/TD]
[TD]19:04[/TD]
[TD]05:18[/TD]
[TD]name6[/TD]
[TD]102[/TD]
[TD]92[/TD]
[TD]65[/TD]
[TD]67[/TD]
[TD]69[/TD]
[TD]71[/TD]
[TD]62[/TD]
[TD]64[/TD]
[TD]66[/TD]
[TD]658[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]29/10/2017[/TD]
[TD]1017-1031[/TD]
[TD]14:05[/TD]
[TD]19:29[/TD]
[TD]05:24[/TD]
[TD]name7[/TD]
[TD]103[/TD]
[TD]95[/TD]
[TD]67[/TD]
[TD]69[/TD]
[TD]71[/TD]
[TD]73[/TD]
[TD]64[/TD]
[TD]66[/TD]
[TD]68[/TD]
[TD]676[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]30/10/2017[/TD]
[TD]1017-1032[/TD]
[TD]14:24[/TD]
[TD]19:54[/TD]
[TD]05:30[/TD]
[TD]name8[/TD]
[TD]104[/TD]
[TD]98[/TD]
[TD]69[/TD]
[TD]71[/TD]
[TD]73[/TD]
[TD]75[/TD]
[TD]66[/TD]
[TD]68[/TD]
[TD]70[/TD]
[TD]694[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]31/10/2017[/TD]
[TD]1017-1033[/TD]
[TD]14:43[/TD]
[TD]20:19[/TD]
[TD]05:36[/TD]
[TD]name1[/TD]
[TD]105[/TD]
[TD]101[/TD]
[TD]71[/TD]
[TD]73[/TD]
[TD]75[/TD]
[TD]77[/TD]
[TD]68[/TD]
[TD]70[/TD]
[TD]72[/TD]
[TD]712[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]01/11/2017[/TD]
[TD]1117-1034[/TD]
[TD]15:02[/TD]
[TD]20:44[/TD]
[TD]05:42[/TD]
[TD]name2[/TD]
[TD]106[/TD]
[TD]104[/TD]
[TD]73[/TD]
[TD]75[/TD]
[TD]77[/TD]
[TD]79[/TD]
[TD]70[/TD]
[TD]72[/TD]
[TD]74[/TD]
[TD]730[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]02/11/2017[/TD]
[TD]1117-1035[/TD]
[TD]15:21[/TD]
[TD]21:09[/TD]
[TD]05:48[/TD]
[TD]name3[/TD]
[TD]107[/TD]
[TD]107[/TD]
[TD]75[/TD]
[TD]77[/TD]
[TD]79[/TD]
[TD]81[/TD]
[TD]72[/TD]
[TD]74[/TD]
[TD]76[/TD]
[TD]748[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]03/11/2017[/TD]
[TD]1117-1036[/TD]
[TD]15:40[/TD]
[TD]21:34[/TD]
[TD]05:54[/TD]
[TD]name4[/TD]
[TD]108[/TD]
[TD]110[/TD]
[TD]77[/TD]
[TD]79[/TD]
[TD]81[/TD]
[TD]83[/TD]
[TD]74[/TD]
[TD]76[/TD]
[TD]78[/TD]
[TD]766[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]04/11/2017[/TD]
[TD]1117-1037[/TD]
[TD]15:59[/TD]
[TD]21:59[/TD]
[TD]06:00[/TD]
[TD]name5[/TD]
[TD]109[/TD]
[TD]113[/TD]
[TD]79[/TD]
[TD]81[/TD]
[TD]83[/TD]
[TD]85[/TD]
[TD]76[/TD]
[TD]78[/TD]
[TD]80[/TD]
[TD]784[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]05/11/2017[/TD]
[TD]1117-1038[/TD]
[TD]16:18[/TD]
[TD]22:24[/TD]
[TD]06:06[/TD]
[TD]name6[/TD]
[TD]110[/TD]
[TD]116[/TD]
[TD]81[/TD]
[TD]83[/TD]
[TD]85[/TD]
[TD]87[/TD]
[TD]78[/TD]
[TD]80[/TD]
[TD]82[/TD]
[TD]802[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]06/11/2017[/TD]
[TD]1117-1039[/TD]
[TD]16:37[/TD]
[TD]22:49[/TD]
[TD]06:12[/TD]
[TD]name7[/TD]
[TD]111[/TD]
[TD]119[/TD]
[TD]83[/TD]
[TD]85[/TD]
[TD]87[/TD]
[TD]89[/TD]
[TD]80[/TD]
[TD]82[/TD]
[TD]84[/TD]
[TD]820[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]07/11/2017[/TD]
[TD]1117-1040[/TD]
[TD]16:56[/TD]
[TD]23:14[/TD]
[TD]06:18[/TD]
[TD]name8[/TD]
[TD]112[/TD]
[TD]122[/TD]
[TD]85[/TD]
[TD]87[/TD]
[TD]89[/TD]
[TD]91[/TD]
[TD]82[/TD]
[TD]84[/TD]
[TD]86[/TD]
[TD]838[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]FRIDAYS[/TD]
[TD]col Q[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]29/09/2017[/TD]
[TD="align: right"]1330[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]one step at a time[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]06/10/2017[/TD]
[TD="align: right"]2212[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]13/10/2017[/TD]
[TD="align: right"]3094[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 8"]by listing the dates of the Fridays easy to total for weeks ending on Thursdays[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]20/10/2017[/TD]
[TD="align: right"]3976[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]27/10/2017[/TD]
[TD="align: right"]4858[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]03/11/2017[/TD]
[TD="align: right"]4010[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]10/11/2017[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]17/11/2017[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]24/11/2017[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
This is looking great. Have the totals in column Q but when compiling that also need totals for the weekly stats for columns F, H through Q and will be inserted at the beginning of the data with the date listed as the Friday's date. I think I misspoke and the subtotals of the data by the week should end on the friday entered to search for and go back to the previous Saturday. The data week is always Saturday through Friday. I realize your sorted and subtotaled data can be moved to the location that I will ultimately assign it when I put a specific template into a specific set of cells.
When the totals/subtotals are calculated can a blank row be inserted into the data to seperate one week from the next and as each week is calculated a blank row would be inserted? When inserting that blank row can we color it a medium grey where not information would be there?

This is looking so great, thank you.
 
Upvote 0
[TABLE="width: 1239"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="5"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]col Q[/TD]
[TD][/TD]
[TD][/TD]
[TD]helper[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]30/09/2017[/TD]
[TD]0917-1001[/TD]
[TD]04:35[/TD]
[TD]06:59[/TD]
[TD]02:24[/TD]
[TD]name1[/TD]
[TD]73[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]9[/TD]
[TD]11[/TD]
[TD]13[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]136[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]30/09/2017[/TD]
[TD] [/TD]
[TD]04:54[/TD]
[TD]07:24[/TD]
[TD]02:30[/TD]
[TD]name2[/TD]
[TD]74[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]11[/TD]
[TD]13[/TD]
[TD]15[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]154[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]01/10/2017[/TD]
[TD]1017-1003[/TD]
[TD]05:13[/TD]
[TD]07:49[/TD]
[TD]02:36[/TD]
[TD]name3[/TD]
[TD]75[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD]13[/TD]
[TD]15[/TD]
[TD]17[/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]12[/TD]
[TD]172[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]02/10/2017[/TD]
[TD] [/TD]
[TD]05:32[/TD]
[TD]08:14[/TD]
[TD]02:42[/TD]
[TD]name4[/TD]
[TD]76[/TD]
[TD]14[/TD]
[TD]13[/TD]
[TD]15[/TD]
[TD]17[/TD]
[TD]19[/TD]
[TD]10[/TD]
[TD]12[/TD]
[TD]14[/TD]
[TD]190[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]03/10/2017[/TD]
[TD]1017-1005[/TD]
[TD]05:51[/TD]
[TD]08:39[/TD]
[TD]02:48[/TD]
[TD]name5[/TD]
[TD]77[/TD]
[TD]17[/TD]
[TD]15[/TD]
[TD]17[/TD]
[TD]19[/TD]
[TD]21[/TD]
[TD]12[/TD]
[TD]14[/TD]
[TD]16[/TD]
[TD]208[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]04/10/2017[/TD]
[TD]1017-1006[/TD]
[TD]06:10[/TD]
[TD]09:04[/TD]
[TD]02:54[/TD]
[TD]name6[/TD]
[TD]78[/TD]
[TD]20[/TD]
[TD]17[/TD]
[TD]19[/TD]
[TD]21[/TD]
[TD]23[/TD]
[TD]14[/TD]
[TD]16[/TD]
[TD]18[/TD]
[TD]226[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]05/10/2017[/TD]
[TD]1017-1007[/TD]
[TD]06:29[/TD]
[TD]09:29[/TD]
[TD]03:00[/TD]
[TD]name7[/TD]
[TD]79[/TD]
[TD]23[/TD]
[TD]19[/TD]
[TD]21[/TD]
[TD]23[/TD]
[TD]25[/TD]
[TD]16[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]244[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]06/10/2017[/TD]
[TD]1017-1008[/TD]
[TD]06:48[/TD]
[TD]09:54[/TD]
[TD]03:06[/TD]
[TD]name8[/TD]
[TD]80[/TD]
[TD]26[/TD]
[TD]21[/TD]
[TD]23[/TD]
[TD]25[/TD]
[TD]27[/TD]
[TD]18[/TD]
[TD]20[/TD]
[TD]22[/TD]
[TD]262[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]07/10/2017[/TD]
[TD]1017-1009[/TD]
[TD]07:07[/TD]
[TD]10:19[/TD]
[TD]03:12[/TD]
[TD]name1[/TD]
[TD]81[/TD]
[TD]29[/TD]
[TD]23[/TD]
[TD]25[/TD]
[TD]27[/TD]
[TD]29[/TD]
[TD]20[/TD]
[TD]22[/TD]
[TD]24[/TD]
[TD]280[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]08/10/2017[/TD]
[TD]1017-1010[/TD]
[TD]07:26[/TD]
[TD]10:44[/TD]
[TD]03:18[/TD]
[TD]name2[/TD]
[TD]82[/TD]
[TD]32[/TD]
[TD]25[/TD]
[TD]27[/TD]
[TD]29[/TD]
[TD]31[/TD]
[TD]22[/TD]
[TD]24[/TD]
[TD]26[/TD]
[TD]298[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]09/10/2017[/TD]
[TD]1017-1011[/TD]
[TD]07:45[/TD]
[TD]11:09[/TD]
[TD]03:24[/TD]
[TD]name3[/TD]
[TD]83[/TD]
[TD]35[/TD]
[TD]27[/TD]
[TD]29[/TD]
[TD]31[/TD]
[TD]33[/TD]
[TD]24[/TD]
[TD]26[/TD]
[TD]28[/TD]
[TD]316[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]10/10/2017[/TD]
[TD]1017-1012[/TD]
[TD]08:04[/TD]
[TD]11:34[/TD]
[TD]03:30[/TD]
[TD]name4[/TD]
[TD]84[/TD]
[TD]38[/TD]
[TD]29[/TD]
[TD]31[/TD]
[TD]33[/TD]
[TD]35[/TD]
[TD]26[/TD]
[TD]28[/TD]
[TD]30[/TD]
[TD]334[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]11/10/2017[/TD]
[TD]1017-1013[/TD]
[TD]08:23[/TD]
[TD]11:59[/TD]
[TD]03:36[/TD]
[TD]name5[/TD]
[TD]85[/TD]
[TD]41[/TD]
[TD]31[/TD]
[TD]33[/TD]
[TD]35[/TD]
[TD]37[/TD]
[TD]28[/TD]
[TD]30[/TD]
[TD]32[/TD]
[TD]352[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]12/10/2017[/TD]
[TD]1017-1014[/TD]
[TD]08:42[/TD]
[TD]12:24[/TD]
[TD]03:42[/TD]
[TD]name6[/TD]
[TD]86[/TD]
[TD]44[/TD]
[TD]33[/TD]
[TD]35[/TD]
[TD]37[/TD]
[TD]39[/TD]
[TD]30[/TD]
[TD]32[/TD]
[TD]34[/TD]
[TD]370[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]13/10/2017[/TD]
[TD]1017-1015[/TD]
[TD]09:01[/TD]
[TD]12:49[/TD]
[TD]03:48[/TD]
[TD]name7[/TD]
[TD]87[/TD]
[TD]47[/TD]
[TD]35[/TD]
[TD]37[/TD]
[TD]39[/TD]
[TD]41[/TD]
[TD]32[/TD]
[TD]34[/TD]
[TD]36[/TD]
[TD]388[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]14/10/2017[/TD]
[TD]1017-1016[/TD]
[TD]09:20[/TD]
[TD]13:14[/TD]
[TD]03:54[/TD]
[TD]name8[/TD]
[TD]88[/TD]
[TD]50[/TD]
[TD]37[/TD]
[TD]39[/TD]
[TD]41[/TD]
[TD]43[/TD]
[TD]34[/TD]
[TD]36[/TD]
[TD]38[/TD]
[TD]406[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]15/10/2017[/TD]
[TD]1017-1017[/TD]
[TD]09:39[/TD]
[TD]13:39[/TD]
[TD]04:00[/TD]
[TD]name1[/TD]
[TD]89[/TD]
[TD]53[/TD]
[TD]39[/TD]
[TD]41[/TD]
[TD]43[/TD]
[TD]45[/TD]
[TD]36[/TD]
[TD]38[/TD]
[TD]40[/TD]
[TD]424[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]16/10/2017[/TD]
[TD]1017-1018[/TD]
[TD]09:58[/TD]
[TD]14:04[/TD]
[TD]04:06[/TD]
[TD]name2[/TD]
[TD]90[/TD]
[TD]56[/TD]
[TD]41[/TD]
[TD]43[/TD]
[TD]45[/TD]
[TD]47[/TD]
[TD]38[/TD]
[TD]40[/TD]
[TD]42[/TD]
[TD]442[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]17/10/2017[/TD]
[TD]1017-1019[/TD]
[TD]10:17[/TD]
[TD]14:29[/TD]
[TD]04:12[/TD]
[TD]name3[/TD]
[TD]91[/TD]
[TD]59[/TD]
[TD]43[/TD]
[TD]45[/TD]
[TD]47[/TD]
[TD]49[/TD]
[TD]40[/TD]
[TD]42[/TD]
[TD]44[/TD]
[TD]460[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]18/10/2017[/TD]
[TD]1017-1020[/TD]
[TD]10:36[/TD]
[TD]14:54[/TD]
[TD]04:18[/TD]
[TD]name4[/TD]
[TD]92[/TD]
[TD]62[/TD]
[TD]45[/TD]
[TD]47[/TD]
[TD]49[/TD]
[TD]51[/TD]
[TD]42[/TD]
[TD]44[/TD]
[TD]46[/TD]
[TD]478[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]19/10/2017[/TD]
[TD]1017-1021[/TD]
[TD]10:55[/TD]
[TD]15:19[/TD]
[TD]04:24[/TD]
[TD]name5[/TD]
[TD]93[/TD]
[TD]65[/TD]
[TD]47[/TD]
[TD]49[/TD]
[TD]51[/TD]
[TD]53[/TD]
[TD]44[/TD]
[TD]46[/TD]
[TD]48[/TD]
[TD]496[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]20/10/2017[/TD]
[TD]1017-1022[/TD]
[TD]11:14[/TD]
[TD]15:44[/TD]
[TD]04:30[/TD]
[TD]name6[/TD]
[TD]94[/TD]
[TD]68[/TD]
[TD]49[/TD]
[TD]51[/TD]
[TD]53[/TD]
[TD]55[/TD]
[TD]46[/TD]
[TD]48[/TD]
[TD]50[/TD]
[TD]514[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]21/10/2017[/TD]
[TD]1017-1023[/TD]
[TD]11:33[/TD]
[TD]16:09[/TD]
[TD]04:36[/TD]
[TD]name7[/TD]
[TD]95[/TD]
[TD]71[/TD]
[TD]51[/TD]
[TD]53[/TD]
[TD]55[/TD]
[TD]57[/TD]
[TD]48[/TD]
[TD]50[/TD]
[TD]52[/TD]
[TD]532[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]22/10/2017[/TD]
[TD]1017-1024[/TD]
[TD]11:52[/TD]
[TD]16:34[/TD]
[TD]04:42[/TD]
[TD]name8[/TD]
[TD]96[/TD]
[TD]74[/TD]
[TD]53[/TD]
[TD]55[/TD]
[TD]57[/TD]
[TD]59[/TD]
[TD]50[/TD]
[TD]52[/TD]
[TD]54[/TD]
[TD]550[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]23/10/2017[/TD]
[TD]1017-1025[/TD]
[TD]12:11[/TD]
[TD]16:59[/TD]
[TD]04:48[/TD]
[TD]name1[/TD]
[TD]97[/TD]
[TD]77[/TD]
[TD]55[/TD]
[TD]57[/TD]
[TD]59[/TD]
[TD]61[/TD]
[TD]52[/TD]
[TD]54[/TD]
[TD]56[/TD]
[TD]568[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]24/10/2017[/TD]
[TD]1017-1026[/TD]
[TD]12:30[/TD]
[TD]17:24[/TD]
[TD]04:54[/TD]
[TD]name2[/TD]
[TD]98[/TD]
[TD]80[/TD]
[TD]57[/TD]
[TD]59[/TD]
[TD]61[/TD]
[TD]63[/TD]
[TD]54[/TD]
[TD]56[/TD]
[TD]58[/TD]
[TD]586[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]25/10/2017[/TD]
[TD]1017-1027[/TD]
[TD]12:49[/TD]
[TD]17:49[/TD]
[TD]05:00[/TD]
[TD]name3[/TD]
[TD]99[/TD]
[TD]83[/TD]
[TD]59[/TD]
[TD]61[/TD]
[TD]63[/TD]
[TD]65[/TD]
[TD]56[/TD]
[TD]58[/TD]
[TD]60[/TD]
[TD]604[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]26/10/2017[/TD]
[TD]1017-1028[/TD]
[TD]13:08[/TD]
[TD]18:14[/TD]
[TD]05:06[/TD]
[TD]name4[/TD]
[TD]100[/TD]
[TD]86[/TD]
[TD]61[/TD]
[TD]63[/TD]
[TD]65[/TD]
[TD]67[/TD]
[TD]58[/TD]
[TD]60[/TD]
[TD]62[/TD]
[TD]622[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]27/10/2017[/TD]
[TD]1017-1029[/TD]
[TD]13:27[/TD]
[TD]18:39[/TD]
[TD]05:12[/TD]
[TD]name5[/TD]
[TD]101[/TD]
[TD]89[/TD]
[TD]63[/TD]
[TD]65[/TD]
[TD]67[/TD]
[TD]69[/TD]
[TD]60[/TD]
[TD]62[/TD]
[TD]64[/TD]
[TD]640[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]28/10/2017[/TD]
[TD]1017-1030[/TD]
[TD]13:46[/TD]
[TD]19:04[/TD]
[TD]05:18[/TD]
[TD]name6[/TD]
[TD]102[/TD]
[TD]92[/TD]
[TD]65[/TD]
[TD]67[/TD]
[TD]69[/TD]
[TD]71[/TD]
[TD]62[/TD]
[TD]64[/TD]
[TD]66[/TD]
[TD]658[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]29/10/2017[/TD]
[TD]1017-1031[/TD]
[TD]14:05[/TD]
[TD]19:29[/TD]
[TD]05:24[/TD]
[TD]name7[/TD]
[TD]103[/TD]
[TD]95[/TD]
[TD]67[/TD]
[TD]69[/TD]
[TD]71[/TD]
[TD]73[/TD]
[TD]64[/TD]
[TD]66[/TD]
[TD]68[/TD]
[TD]676[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]30/10/2017[/TD]
[TD]1017-1032[/TD]
[TD]14:24[/TD]
[TD]19:54[/TD]
[TD]05:30[/TD]
[TD]name8[/TD]
[TD]104[/TD]
[TD]98[/TD]
[TD]69[/TD]
[TD]71[/TD]
[TD]73[/TD]
[TD]75[/TD]
[TD]66[/TD]
[TD]68[/TD]
[TD]70[/TD]
[TD]694[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]31/10/2017[/TD]
[TD]1017-1033[/TD]
[TD]14:43[/TD]
[TD]20:19[/TD]
[TD]05:36[/TD]
[TD]name1[/TD]
[TD]105[/TD]
[TD]101[/TD]
[TD]71[/TD]
[TD]73[/TD]
[TD]75[/TD]
[TD]77[/TD]
[TD]68[/TD]
[TD]70[/TD]
[TD]72[/TD]
[TD]712[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]01/11/2017[/TD]
[TD]1117-1034[/TD]
[TD]15:02[/TD]
[TD]20:44[/TD]
[TD]05:42[/TD]
[TD]name2[/TD]
[TD]106[/TD]
[TD]104[/TD]
[TD]73[/TD]
[TD]75[/TD]
[TD]77[/TD]
[TD]79[/TD]
[TD]70[/TD]
[TD]72[/TD]
[TD]74[/TD]
[TD]730[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]02/11/2017[/TD]
[TD]1117-1035[/TD]
[TD]15:21[/TD]
[TD]21:09[/TD]
[TD]05:48[/TD]
[TD]name3[/TD]
[TD]107[/TD]
[TD]107[/TD]
[TD]75[/TD]
[TD]77[/TD]
[TD]79[/TD]
[TD]81[/TD]
[TD]72[/TD]
[TD]74[/TD]
[TD]76[/TD]
[TD]748[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]03/11/2017[/TD]
[TD]1117-1036[/TD]
[TD]15:40[/TD]
[TD]21:34[/TD]
[TD]05:54[/TD]
[TD]name4[/TD]
[TD]108[/TD]
[TD]110[/TD]
[TD]77[/TD]
[TD]79[/TD]
[TD]81[/TD]
[TD]83[/TD]
[TD]74[/TD]
[TD]76[/TD]
[TD]78[/TD]
[TD]766[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]04/11/2017[/TD]
[TD]1117-1037[/TD]
[TD]15:59[/TD]
[TD]21:59[/TD]
[TD]06:00[/TD]
[TD]name5[/TD]
[TD]109[/TD]
[TD]113[/TD]
[TD]79[/TD]
[TD]81[/TD]
[TD]83[/TD]
[TD]85[/TD]
[TD]76[/TD]
[TD]78[/TD]
[TD]80[/TD]
[TD]784[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]05/11/2017[/TD]
[TD]1117-1038[/TD]
[TD]16:18[/TD]
[TD]22:24[/TD]
[TD]06:06[/TD]
[TD]name6[/TD]
[TD]110[/TD]
[TD]116[/TD]
[TD]81[/TD]
[TD]83[/TD]
[TD]85[/TD]
[TD]87[/TD]
[TD]78[/TD]
[TD]80[/TD]
[TD]82[/TD]
[TD]802[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]06/11/2017[/TD]
[TD]1117-1039[/TD]
[TD]16:37[/TD]
[TD]22:49[/TD]
[TD]06:12[/TD]
[TD]name7[/TD]
[TD]111[/TD]
[TD]119[/TD]
[TD]83[/TD]
[TD]85[/TD]
[TD]87[/TD]
[TD]89[/TD]
[TD]80[/TD]
[TD]82[/TD]
[TD]84[/TD]
[TD]820[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]07/11/2017[/TD]
[TD]1117-1040[/TD]
[TD]16:56[/TD]
[TD]23:14[/TD]
[TD]06:18[/TD]
[TD]name8[/TD]
[TD]112[/TD]
[TD]122[/TD]
[TD]85[/TD]
[TD]87[/TD]
[TD]89[/TD]
[TD]91[/TD]
[TD]82[/TD]
[TD]84[/TD]
[TD]86[/TD]
[TD]838[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SATURDAYS[/TD]
[TD]col Q[/TD]
[TD]col F[/TD]
[TD]col H[/TD]
[TD]col I[/TD]
[TD]col J[/TD]
[TD]col K[/TD]
[TD]col L[/TD]
[TD]col M[/TD]
[TD]col N[/TD]
[TD]col O[/TD]
[TD]col P[/TD]
[TD][/TD]
[TD]col C count<>""[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]30/09/2017[/TD]
[TD]1592[/TD]
[TD]22:00[/TD]
[TD]612[/TD]
[TD]124[/TD]
[TD]112[/TD]
[TD]128[/TD]
[TD]144[/TD]
[TD]160[/TD]
[TD]88[/TD]
[TD]104[/TD]
[TD]120[/TD]
[TD][/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]07/10/2017[/TD]
[TD]2338[/TD]
[TD]00:30[/TD]
[TD]588[/TD]
[TD]266[/TD]
[TD]203[/TD]
[TD]217[/TD]
[TD]231[/TD]
[TD]245[/TD]
[TD]182[/TD]
[TD]196[/TD]
[TD]210[/TD]
[TD][/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]14/10/2017[/TD]
[TD]3220[/TD]
[TD]05:24[/TD]
[TD]637[/TD]
[TD]413[/TD]
[TD]301[/TD]
[TD]315[/TD]
[TD]329[/TD]
[TD]343[/TD]
[TD]280[/TD]
[TD]294[/TD]
[TD]308[/TD]
[TD][/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]21/10/2017[/TD]
[TD]4102[/TD]
[TD]10:18[/TD]
[TD]686[/TD]
[TD]560[/TD]
[TD]399[/TD]
[TD]413[/TD]
[TD]427[/TD]
[TD]441[/TD]
[TD]378[/TD]
[TD]392[/TD]
[TD]406[/TD]
[TD][/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]28/10/2017[/TD]
[TD]4984[/TD]
[TD]15:12[/TD]
[TD]735[/TD]
[TD]707[/TD]
[TD]497[/TD]
[TD]511[/TD]
[TD]525[/TD]
[TD]539[/TD]
[TD]476[/TD]
[TD]490[/TD]
[TD]504[/TD]
[TD][/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]04/11/2017[/TD]
[TD]3244[/TD]
[TD]00:36[/TD]
[TD]442[/TD]
[TD]470[/TD]
[TD]328[/TD]
[TD]336[/TD]
[TD]344[/TD]
[TD]352[/TD]
[TD]316[/TD]
[TD]324[/TD]
[TD]332[/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]11/11/2017[/TD]
[TD]0[/TD]
[TD]00:00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]18/11/2017[/TD]
[TD]0[/TD]
[TD]00:00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]25/11/2017[/TD]
[TD]0[/TD]
[TD]00:00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 8"]I am working on col F as when hours total over 24 they reset to zero[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]week is now sat to Friday[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 6"]for testing purposes I deleted a couple of col C id's[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
the data can be in any order so not sure how and why you want rows moved and spaces inserted..........
 
Upvote 0
This is looking so great. The hours used to reset for me too but when I formated the time to be [h]:mm:ss;@ it seemed to correct it. I did eliminate the "ss" part because I didn't need seconds.

When the report is presented to my superior's I will provide them with the weekly summary which will be the pasted part of the form. All these calculations occur there. The addition of a blank line after each week was subtotaled helps clarify the division between each week and was something the Major wanted me to do. If doable great if not no prob. To address your question about moving the subtotals into the rows in looking back at it I don't. I will keep the subtotals always displayed where they were going to be pasted. So the rows that I was going to insert will already have the formatting inserted and no need to copy from another part of the sheet. I didn't think that one clearly enough. The blank column will be helpful to look at the weeks for specific data and see where it ends. I will make a new note to you confirming the exact locations and such that each of the subtotaled data goes into. I'll post soon. thanks so much
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,323
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top