Spilt a date range into one row per day

[liorchn]

Hi there,

Can you please help me (I guess with a macro code) how to split a date range into one day per row.

Ive got an excel sheet with 30,000 rows which contains an absence leaves of the company employees (emp number, emp name, absence code, start date, end date).

I want that every row contain only one day and not a date range (I know that this will lead to the addition of many roes but i dont have a choise)

Thank you very much​

 

[alzon21]

Hi please help me how to make VBA for this.

from a daily to consolidated weekly base on the days of operation.

it splits the row because there is no schedule on 21-oct-2015. may be the flight was cancelled.

[TABLE="width: 832"]
<colgroup><col width="64" span="13" style="width: 48pt;"></colgroup><tbody>[TR]
[TD="class: xl66, width: 64"]A[/TD]
[TD="class: xl67, width: 64"]B[/TD]
[TD="class: xl67, width: 64"]C[/TD]
[TD="class: xl67, width: 64"]D[/TD]
[TD="class: xl67, width: 64"]E[/TD]
[TD="class: xl67, width: 64"]F[/TD]
[TD="class: xl67, width: 64"]G[/TD]
[TD="class: xl67, width: 64"]H[/TD]
[TD="class: xl67, width: 64"]I[/TD]
[TD="class: xl67, width: 64"]J[/TD]
[TD="class: xl67, width: 64"]K[/TD]
[TD="class: xl67, width: 64"]L[/TD]
[TD="class: xl68, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]1[/TD]
[TD="class: xl63, width: 64"]DATA:[/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl70, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]2[/TD]
[TD="class: xl63, width: 64"]Carrier IATA code[/TD]
[TD="class: xl63, width: 64"]Flight number[/TD]
[TD="class: xl63, width: 64"]Date[/TD]
[TD="class: xl63, width: 64"]Days of Operation numeric values (MTWTFSS) (1234567)[/TD]
[TD="class: xl63, width: 64"]Departure[/TD]
[TD="class: xl63, width: 64"]Dep Time[/TD]
[TD="class: xl63, width: 64"]Arrival[/TD]
[TD="class: xl63, width: 64"]Arr Time[/TD]
[TD="class: xl63, width: 64"]Seat[/TD]
[TD="class: xl63, width: 64"]Acft code (IATA)[/TD]
[TD="class: xl63, width: 64"]Service Type[/TD]
[TD="class: xl70, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]9[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]2-Oct-15[/TD]
[TD="class: xl63, width: 64"]5[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]10[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]5-Oct-15[/TD]
[TD="class: xl63, width: 64"]1[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]11[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]7-Oct-15[/TD]
[TD="class: xl63, width: 64"]3[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]12[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]9-Oct-15[/TD]
[TD="class: xl63, width: 64"]5[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]13[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]12-Oct-15[/TD]
[TD="class: xl63, width: 64"]1[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]14[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]14-Oct-15[/TD]
[TD="class: xl63, width: 64"]3[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]15[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]16-Oct-15[/TD]
[TD="class: xl63, width: 64"]5[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]16[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]19-Oct-15[/TD]
[TD="class: xl63, width: 64"]1[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]17[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]23-Oct-15[/TD]
[TD="class: xl63, width: 64"]5[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]18[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]26-Oct-15[/TD]
[TD="class: xl63, width: 64"]1[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]19[/TD]
[TD="class: xl63, width: 64"]RESULT[/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl64, width: 64"] [/TD]
[TD="class: xl70, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]20[/TD]
[TD="class: xl63, width: 64"]Carrier IATA code[/TD]
[TD="class: xl63, width: 64"]Flight number[/TD]
[TD="class: xl63, width: 64"]Effective From DDMMMYY[/TD]
[TD="class: xl63, width: 64"]Effective To DDMMMYY[/TD]
[TD="class: xl63, width: 64"]Days of Operation numeric values (MTWTFSS) (1234567)[/TD]
[TD="class: xl63, width: 64"]Departure[/TD]
[TD="class: xl63, width: 64"]Dep Time[/TD]
[TD="class: xl63, width: 64"]Arrival[/TD]
[TD="class: xl63, width: 64"]Arr Time[/TD]
[TD="class: xl63, width: 64"]Seat[/TD]
[TD="class: xl63, width: 64"]Acft code (IATA)[/TD]
[TD="class: xl71, width: 64"]Service Type[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]21[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]2-Oct-15[/TD]
[TD="class: xl65, width: 64"]19-Oct-15[/TD]
[TD="class: xl63, width: 64"]135[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl71, width: 64"]K[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]22[/TD]
[TD="class: xl72, width: 64"]2XZ[/TD]
[TD="class: xl72, width: 64"]207[/TD]
[TD="class: xl73, width: 64"]23-Oct-15[/TD]
[TD="class: xl73, width: 64"]26-Oct-15[/TD]
[TD="class: xl72, width: 64"]15[/TD]
[TD="class: xl72, width: 64"]MNL[/TD]
[TD="class: xl72, width: 64"]1025[/TD]
[TD="class: xl72, width: 64"]SYD[/TD]
[TD="class: xl72, width: 64"]2015[/TD]
[TD="class: xl72, width: 64"]230[/TD]
[TD="class: xl72, width: 64"]388[/TD]
[TD="class: xl74, width: 64"]K[/TD]
[/TR]
</tbody>[/TABLE]


thanks

Without further guidance/information, I don't see how that could be done logically/consistently. For example, using your sample data for Flight number 207...

- Rows 23-24 below show your expected results.

- Rows 26-27 show a different set of results that seem to me to also fit the same original data.

Also, why does your first 207 result row use a start date of 1-Oct-15 when the first 207 flight is on 2-Oct-15?

Sheet2

*

A

B

C

D

E

F

G

H

I

J

K

L

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

*

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:69px;"><col style="width:80px;"><col style="width:110px;"><col style="width:170px;"><col style="width:125px;"><col style="width:75px;"><col style="width:57px;"><col style="width:51px;"><col style="width:52px;"><col style="width:67px;"><col style="width:65px;"><col style="width:58px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="align: center"]DATA:[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: center"]Carrier IATA code[/TD]
[TD="align: center"]Flight number[/TD]
[TD="align: center"]Date[/TD]
[TD="align: center"]Days of Operation numeric values (MTWTFSS) (1234567)[/TD]
[TD="align: center"]Departure[/TD]
[TD="align: center"]Dep Time[/TD]
[TD="align: center"]Arrival[/TD]
[TD="align: center"]Arr Time[/TD]
[TD="align: center"]Seat[/TD]
[TD="align: center"]Acft code (IATA)[/TD]
[TD="align: center"]Service Type[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: center"]2XZ[/TD]
[TD="align: center"]207[/TD]
[TD="align: center"]2-Oct-15[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]MNL[/TD]
[TD="align: center"]1025[/TD]
[TD="align: center"]SYD[/TD]
[TD="align: center"]2015[/TD]
[TD="align: center"]230[/TD]
[TD="align: center"]388[/TD]
[TD="align: center"]K[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]
[TD="align: center"]2XZ[/TD]
[TD="align: center"]207[/TD]
[TD="align: center"]5-Oct-15[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]MNL[/TD]
[TD="align: center"]1025[/TD]
[TD="align: center"]SYD[/TD]
[TD="align: center"]2015[/TD]
[TD="align: center"]230[/TD]
[TD="align: center"]388[/TD]
[TD="align: center"]K[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]
[TD="align: center"]2XZ[/TD]
[TD="align: center"]207[/TD]
[TD="align: center"]7-Oct-15[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]MNL[/TD]
[TD="align: center"]1025[/TD]
[TD="align: center"]SYD[/TD]
[TD="align: center"]2015[/TD]
[TD="align: center"]230[/TD]
[TD="align: center"]388[/TD]
[TD="align: center"]K[/TD]

[TD="bgcolor: #cacaca, align: center"]12[/TD]
[TD="align: center"]2XZ[/TD]
[TD="align: center"]207[/TD]
[TD="align: center"]9-Oct-15[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]MNL[/TD]
[TD="align: center"]1025[/TD]
[TD="align: center"]SYD[/TD]
[TD="align: center"]2015[/TD]
[TD="align: center"]230[/TD]
[TD="align: center"]388[/TD]
[TD="align: center"]K[/TD]

[TD="bgcolor: #cacaca, align: center"]13[/TD]
[TD="align: center"]2XZ[/TD]
[TD="align: center"]207[/TD]
[TD="align: center"]12-Oct-15[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]MNL[/TD]
[TD="align: center"]1025[/TD]
[TD="align: center"]SYD[/TD]
[TD="align: center"]2015[/TD]
[TD="align: center"]230[/TD]
[TD="align: center"]388[/TD]
[TD="align: center"]K[/TD]

[TD="bgcolor: #cacaca, align: center"]14[/TD]
[TD="align: center"]2XZ[/TD]
[TD="align: center"]207[/TD]
[TD="align: center"]14-Oct-15[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]MNL[/TD]
[TD="align: center"]1025[/TD]
[TD="align: center"]SYD[/TD]
[TD="align: center"]2015[/TD]
[TD="align: center"]230[/TD]
[TD="align: center"]388[/TD]
[TD="align: center"]K[/TD]

[TD="bgcolor: #cacaca, align: center"]15[/TD]
[TD="align: center"]2XZ[/TD]
[TD="align: center"]207[/TD]
[TD="align: center"]16-Oct-15[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]MNL[/TD]
[TD="align: center"]1025[/TD]
[TD="align: center"]SYD[/TD]
[TD="align: center"]2015[/TD]
[TD="align: center"]230[/TD]
[TD="align: center"]388[/TD]
[TD="align: center"]K[/TD]

[TD="bgcolor: #cacaca, align: center"]16[/TD]
[TD="align: center"]2XZ[/TD]
[TD="align: center"]207[/TD]
[TD="align: center"]19-Oct-15[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]MNL[/TD]
[TD="align: center"]1025[/TD]
[TD="align: center"]SYD[/TD]
[TD="align: center"]2015[/TD]
[TD="align: center"]230[/TD]
[TD="align: center"]388[/TD]
[TD="align: center"]K[/TD]

[TD="bgcolor: #cacaca, align: center"]17[/TD]
[TD="align: center"]2XZ[/TD]
[TD="align: center"]207[/TD]
[TD="align: center"]23-Oct-15[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]MNL[/TD]
[TD="align: center"]1025[/TD]
[TD="align: center"]SYD[/TD]
[TD="align: center"]2015[/TD]
[TD="align: center"]230[/TD]
[TD="align: center"]388[/TD]
[TD="align: center"]K[/TD]

[TD="bgcolor: #cacaca, align: center"]18[/TD]
[TD="align: center"]2XZ[/TD]
[TD="align: center"]207[/TD]
[TD="align: center"]26-Oct-15[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]MNL[/TD]
[TD="align: center"]1025[/TD]
[TD="align: center"]SYD[/TD]
[TD="align: center"]2015[/TD]
[TD="align: center"]230[/TD]
[TD="align: center"]388[/TD]
[TD="align: center"]K[/TD]

[TD="bgcolor: #cacaca, align: center"]19[/TD]
[TD="align: center"]RESULT[/TD]

[TD="bgcolor: #cacaca, align: center"]20[/TD]
[TD="align: center"]Carrier IATA code[/TD]
[TD="align: center"]Flight number[/TD]
[TD="align: center"]Effective From DDMMMYY[/TD]
[TD="align: center"]Effective To DDMMMYY[/TD]
[TD="align: center"]Days of Operation numeric values (MTWTFSS) (1234567)[/TD]
[TD="align: center"]Departure[/TD]
[TD="align: center"]Dep Time[/TD]
[TD="align: center"]Arrival[/TD]
[TD="align: center"]Arr Time[/TD]
[TD="align: center"]Seat[/TD]
[TD="align: center"]Acft code (IATA)[/TD]
[TD="align: center"]Service Type[/TD]

[TD="bgcolor: #cacaca, align: center"]23[/TD]
[TD="align: center"]2XZ[/TD]
[TD="align: center"]207[/TD]
[TD="align: center"]1-Oct-15[/TD]
[TD="align: center"]14-Oct-15[/TD]
[TD="align: center"]135[/TD]
[TD="align: center"]MNL[/TD]
[TD="align: center"]1025[/TD]
[TD="align: center"]SYD[/TD]
[TD="align: center"]2015[/TD]
[TD="align: center"]230[/TD]
[TD="align: center"]388[/TD]
[TD="align: center"]K[/TD]

[TD="bgcolor: #cacaca, align: center"]24[/TD]
[TD="align: center"]2XZ[/TD]
[TD="align: center"]207[/TD]
[TD="align: center"]16-Oct-15[/TD]
[TD="align: center"]26-Oct-15[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]MNL[/TD]
[TD="align: center"]1025[/TD]
[TD="align: center"]SYD[/TD]
[TD="align: center"]2015[/TD]
[TD="align: center"]230[/TD]
[TD="align: center"]388[/TD]
[TD="align: center"]K[/TD]

[TD="bgcolor: #cacaca, align: center"]25[/TD]

[TD="bgcolor: #cacaca, align: center"]26[/TD]
[TD="align: center"]2XZ[/TD]
[TD="align: center"]207[/TD]
[TD="align: center"]2-Oct-15[/TD]
[TD="align: center"]19-Oct-15[/TD]
[TD="align: center"]135[/TD]
[TD="align: center"]MNL[/TD]
[TD="align: center"]1025[/TD]
[TD="align: center"]SYD[/TD]
[TD="align: center"]2015[/TD]
[TD="align: center"]230[/TD]
[TD="align: center"]388[/TD]
[TD="align: center"]K[/TD]

[TD="bgcolor: #cacaca, align: center"]27[/TD]
[TD="align: center"]2XZ[/TD]
[TD="align: center"]207[/TD]
[TD="align: center"]23-Oct-15[/TD]
[TD="align: center"]26-Oct-15[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]MNL[/TD]
[TD="align: center"]1025[/TD]
[TD="align: center"]SYD[/TD]
[TD="align: center"]2015[/TD]
[TD="align: center"]230[/TD]
[TD="align: center"]388[/TD]
[TD="align: center"]K[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[Peter_SSs]

I'm sorry, but I am going to be away from the forum for an extended period so won't be able to help further with this anytime in the next few months.

 

[alzon21]

thanks

Hi Peter sorry for the confusion, what i want is a VBA that combines the daily into weekly depends on the date and day of the week.
let me correct the example below.

from the daily row it will combine those flights into single line as shown"row 21" but should be fall on the day of operation such 135.
from the daily data there is no flight on 21oct15 may be it was cancelled so. the single line with stop at 19 oct 15 as it fall on day 1
now it will insert another row (row 22) for the remaining flight which is 23oct that will fall on day 5 and 26oct will fall on day 1
now the multiple daily lines comes with 2 lines which is easy to read.

thanks peter

[TABLE="width: 832"]
<tbody>[TR]
[TD="class: xl66, width: 64"]A[/TD]
[TD="class: xl67, width: 64"]B[/TD]
[TD="class: xl67, width: 64"]C[/TD]
[TD="class: xl67, width: 64"]D[/TD]
[TD="class: xl67, width: 64"]E[/TD]
[TD="class: xl67, width: 64"]F[/TD]
[TD="class: xl67, width: 64"]G[/TD]
[TD="class: xl67, width: 64"]H[/TD]
[TD="class: xl67, width: 64"]I[/TD]
[TD="class: xl67, width: 64"]J[/TD]
[TD="class: xl67, width: 64"]K[/TD]
[TD="class: xl67, width: 64"]L[/TD]
[TD="class: xl68, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]1[/TD]
[TD="class: xl63, width: 64"]DATA:[/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl70, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]2[/TD]
[TD="class: xl63, width: 64"]Carrier IATA code[/TD]
[TD="class: xl63, width: 64"]Flight number[/TD]
[TD="class: xl63, width: 64"]Date[/TD]
[TD="class: xl63, width: 64"]Days of Operation numeric values (MTWTFSS) (1234567)[/TD]
[TD="class: xl63, width: 64"]Departure[/TD]
[TD="class: xl63, width: 64"]Dep Time[/TD]
[TD="class: xl63, width: 64"]Arrival[/TD]
[TD="class: xl63, width: 64"]Arr Time[/TD]
[TD="class: xl63, width: 64"]Seat[/TD]
[TD="class: xl63, width: 64"]Acft code (IATA)[/TD]
[TD="class: xl63, width: 64"]Service Type[/TD]
[TD="class: xl70, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]9[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]2-Oct-15[/TD]
[TD="class: xl63, width: 64"]5[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]10[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]5-Oct-15[/TD]
[TD="class: xl63, width: 64"]1[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]11[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]7-Oct-15[/TD]
[TD="class: xl63, width: 64"]3[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]12[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]9-Oct-15[/TD]
[TD="class: xl63, width: 64"]5[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]13[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]12-Oct-15[/TD]
[TD="class: xl63, width: 64"]1[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]14[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]14-Oct-15[/TD]
[TD="class: xl63, width: 64"]3[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]15[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]16-Oct-15[/TD]
[TD="class: xl63, width: 64"]5[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]16[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]19-Oct-15[/TD]
[TD="class: xl63, width: 64"]1[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]17[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]23-Oct-15[/TD]
[TD="class: xl63, width: 64"]5[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]18[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]26-Oct-15[/TD]
[TD="class: xl63, width: 64"]1[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl63, width: 64"]K[/TD]
[TD="class: xl70, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]19[/TD]
[TD="class: xl63, width: 64"]RESULT[/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl70, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]20[/TD]
[TD="class: xl63, width: 64"]Carrier IATA code[/TD]
[TD="class: xl63, width: 64"]Flight number[/TD]
[TD="class: xl63, width: 64"]Effective From DDMMMYY[/TD]
[TD="class: xl63, width: 64"]Effective To DDMMMYY[/TD]
[TD="class: xl63, width: 64"]Days of Operation numeric values (MTWTFSS) (1234567)[/TD]
[TD="class: xl63, width: 64"]Departure[/TD]
[TD="class: xl63, width: 64"]Dep Time[/TD]
[TD="class: xl63, width: 64"]Arrival[/TD]
[TD="class: xl63, width: 64"]Arr Time[/TD]
[TD="class: xl63, width: 64"]Seat[/TD]
[TD="class: xl63, width: 64"]Acft code (IATA)[/TD]
[TD="class: xl71, width: 64"]Service Type[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]21[/TD]
[TD="class: xl63, width: 64"]2XZ[/TD]
[TD="class: xl63, width: 64"]207[/TD]
[TD="class: xl65, width: 64"]2-Oct-15[/TD]
[TD="class: xl65, width: 64"]19-Oct-15[/TD]
[TD="class: xl63, width: 64"]135[/TD]
[TD="class: xl63, width: 64"]MNL[/TD]
[TD="class: xl63, width: 64"]1025[/TD]
[TD="class: xl63, width: 64"]SYD[/TD]
[TD="class: xl63, width: 64"]2015[/TD]
[TD="class: xl63, width: 64"]230[/TD]
[TD="class: xl63, width: 64"]388[/TD]
[TD="class: xl71, width: 64"]K[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]22[/TD]
[TD="class: xl72, width: 64"]2XZ[/TD]
[TD="class: xl72, width: 64"]207[/TD]
[TD="class: xl73, width: 64"]23-Oct-15[/TD]
[TD="class: xl73, width: 64"]26-Oct-15[/TD]
[TD="class: xl72, width: 64"]15[/TD]
[TD="class: xl72, width: 64"]MNL[/TD]
[TD="class: xl72, width: 64"]1025[/TD]
[TD="class: xl72, width: 64"]SYD[/TD]
[TD="class: xl72, width: 64"]2015[/TD]
[TD="class: xl72, width: 64"]230[/TD]
[TD="class: xl72, width: 64"]388[/TD]
[TD="class: xl74, width: 64"]K

[/TD]
[/TR]
</tbody>[/TABLE]