Multiple Sort In Same Column

RandyD123

Active Member
Joined
Dec 4, 2013
Messages
296
Office Version
  1. 2016
Platform
  1. Windows
I am looking to sort using a VBA code that will sort my attached sheet by Airline then by Time. The only catch is that the Airlines must be held together, meaning all DL first by time, then all SW second by time......and so on. Each individual day must sort using the code. Obviously this is only part of the sheet that I attached but I assume if this is even possible I can just continue the code to get all 42 individual calendar blocks.

If possible with on space between each one.

Thank you to anyone that can help.

[TABLE="width: 1650"]
<tbody>[TR]
[TD="colspan: 4"]Tuesday, March 1, 2016[/TD]
[TD][/TD]
[TD="colspan: 4"]Wednesday, March 2, 2016[/TD]
[TD][/TD]
[TD="colspan: 4"]Thursday, March 3, 2016[/TD]
[TD][/TD]
[TD="colspan: 4"]Friday, March 4, 2016[/TD]
[TD][/TD]
[TD="colspan: 4"]Saturday, March 5, 2016[/TD]
[TD][/TD]
[TD="colspan: 4"]Sunday, March 6, 2016[/TD]
[/TR]
[TR]
[TD]Airline[/TD]
[TD]Dest[/TD]
[TD]Time[/TD]
[TD]Cap.[/TD]
[TD][/TD]
[TD]Airline[/TD]
[TD]Dest[/TD]
[TD]Time[/TD]
[TD]Cap.[/TD]
[TD][/TD]
[TD]Airline[/TD]
[TD]Dest[/TD]
[TD]Time[/TD]
[TD]Cap.[/TD]
[TD][/TD]
[TD]Airline[/TD]
[TD]Dest[/TD]
[TD]Time[/TD]
[TD]Cap.[/TD]
[TD][/TD]
[TD]Airline[/TD]
[TD]Dest[/TD]
[TD]Time[/TD]
[TD]Cap.[/TD]
[TD][/TD]
[TD]Airline[/TD]
[TD]Dest[/TD]
[TD]Time[/TD]
[TD]Cap.[/TD]
[/TR]
[TR]
[TD]US4577[/TD]
[TD]DCA[/TD]
[TD]1800[/TD]
[TD]75[/TD]
[TD][/TD]
[TD]US4577[/TD]
[TD]DCA[/TD]
[TD]1800[/TD]
[TD]75[/TD]
[TD][/TD]
[TD]US4577[/TD]
[TD]DCA[/TD]
[TD]1800[/TD]
[TD]75[/TD]
[TD][/TD]
[TD]US4577[/TD]
[TD]DCA[/TD]
[TD]1800[/TD]
[TD]75[/TD]
[TD][/TD]
[TD]US4577[/TD]
[TD]DCA[/TD]
[TD]1800[/TD]
[TD]75[/TD]
[TD][/TD]
[TD]US4577[/TD]
[TD]DCA[/TD]
[TD]1800[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD]US4472[/TD]
[TD]PHL[/TD]
[TD]1500[/TD]
[TD]50[/TD]
[TD]US4472[/TD]
[TD]PHL[/TD]
[TD]1500[/TD]
[TD]50[/TD]
[TD]US4472[/TD]
[TD]PHL[/TD]
[TD]1500[/TD]
[TD]50[/TD]
[TD]US4472[/TD]
[TD]PHL[/TD]
[TD]1500[/TD]
[TD]50[/TD]
[TD]US4472[/TD]
[TD]PHL[/TD]
[TD]1500[/TD]
[TD]50[/TD]
[TD]US4472[/TD]
[TD]PHL[/TD]
[TD]1500[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]US4465[/TD]
[TD]CLT[/TD]
[TD]1200[/TD]
[TD]80[/TD]
[TD]US4465[/TD]
[TD]CLT[/TD]
[TD]1200[/TD]
[TD]80[/TD]
[TD]US4465[/TD]
[TD]CLT[/TD]
[TD]1200[/TD]
[TD]80[/TD]
[TD]US4465[/TD]
[TD]CLT[/TD]
[TD]1200[/TD]
[TD]80[/TD]
[TD]US4465[/TD]
[TD]CLT[/TD]
[TD]1200[/TD]
[TD]80[/TD]
[TD]US4465[/TD]
[TD]CLT[/TD]
[TD]1200[/TD]
[TD]80[/TD]
[/TR]
[TR]
[TD]US3827[/TD]
[TD]PHL[/TD]
[TD]1400[/TD]
[TD]75[/TD]
[TD]US3827[/TD]
[TD]PHL[/TD]
[TD]1400[/TD]
[TD]75[/TD]
[TD]US3827[/TD]
[TD]PHL[/TD]
[TD]1400[/TD]
[TD]75[/TD]
[TD]US3827[/TD]
[TD]PHL[/TD]
[TD]1400[/TD]
[TD]75[/TD]
[TD]US3827[/TD]
[TD]PHL[/TD]
[TD]1400[/TD]
[TD]75[/TD]
[TD]US3827[/TD]
[TD]PHL[/TD]
[TD]1400[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD]US4082[/TD]
[TD]PHL[/TD]
[TD]800[/TD]
[TD]100[/TD]
[TD]US4082[/TD]
[TD]PHL[/TD]
[TD]800[/TD]
[TD]100[/TD]
[TD]US4082[/TD]
[TD]PHL[/TD]
[TD]800[/TD]
[TD]100[/TD]
[TD]US4082[/TD]
[TD]PHL[/TD]
[TD]800[/TD]
[TD]100[/TD]
[TD]US4082[/TD]
[TD]PHL[/TD]
[TD]800[/TD]
[TD]100[/TD]
[TD]US4082[/TD]
[TD]PHL[/TD]
[TD]800[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]US3775[/TD]
[TD]DCA[/TD]
[TD]700[/TD]
[TD]45[/TD]
[TD]US3775[/TD]
[TD]DCA[/TD]
[TD]700[/TD]
[TD]45[/TD]
[TD]US3775[/TD]
[TD]DCA[/TD]
[TD]700[/TD]
[TD]45[/TD]
[TD]US3775[/TD]
[TD]DCA[/TD]
[TD]700[/TD]
[TD]45[/TD]
[TD]US3775[/TD]
[TD]DCA[/TD]
[TD]700[/TD]
[TD]45[/TD]
[TD]US3775[/TD]
[TD]DCA[/TD]
[TD]700[/TD]
[TD]45[/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]
[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]
[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]
[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]
[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]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SW1270[/TD]
[TD]MDW[/TD]
[TD]530[/TD]
[TD]175[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[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]SW647[/TD]
[TD]BWI[/TD]
[TD]555[/TD]
[TD]143[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[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]SW1537[/TD]
[TD]MCO[/TD]
[TD]605[/TD]
[TD]143[/TD]
[TD]SW1270[/TD]
[TD]MDW[/TD]
[TD]530[/TD]
[TD]175[/TD]
[TD]SW1270[/TD]
[TD]MDW[/TD]
[TD]530[/TD]
[TD]175[/TD]
[TD]SW1270[/TD]
[TD]MDW[/TD]
[TD]530[/TD]
[TD]175[/TD]
[TD]SW1270[/TD]
[TD]MDW[/TD]
[TD]530[/TD]
[TD]175[/TD]
[TD]SW1270[/TD]
[TD]MDW[/TD]
[TD]530[/TD]
[TD]175[/TD]
[/TR]
[TR]
[TD]SW452[/TD]
[TD]BWI[/TD]
[TD]700[/TD]
[TD]137[/TD]
[TD]SW647[/TD]
[TD]BWI[/TD]
[TD]555[/TD]
[TD]143[/TD]
[TD]SW647[/TD]
[TD]BWI[/TD]
[TD]555[/TD]
[TD]143[/TD]
[TD]SW647[/TD]
[TD]BWI[/TD]
[TD]555[/TD]
[TD]143[/TD]
[TD]SW647[/TD]
[TD]BWI[/TD]
[TD]555[/TD]
[TD]143[/TD]
[TD]SW647[/TD]
[TD]BWI[/TD]
[TD]555[/TD]
[TD]143[/TD]
[/TR]
[TR]
[TD]SW1092[/TD]
[TD]BWI[/TD]
[TD]400[/TD]
[TD]175[/TD]
[TD]SW1537[/TD]
[TD]MCO[/TD]
[TD]605[/TD]
[TD]143[/TD]
[TD]SW1537[/TD]
[TD]MCO[/TD]
[TD]605[/TD]
[TD]143[/TD]
[TD]SW1537[/TD]
[TD]MCO[/TD]
[TD]605[/TD]
[TD]143[/TD]
[TD]SW1537[/TD]
[TD]MCO[/TD]
[TD]605[/TD]
[TD]143[/TD]
[TD]SW1537[/TD]
[TD]MCO[/TD]
[TD]605[/TD]
[TD]143[/TD]
[/TR]
[TR]
[TD]SW767[/TD]
[TD]BWI[/TD]
[TD]500[/TD]
[TD]143[/TD]
[TD]SW452[/TD]
[TD]BWI[/TD]
[TD]700[/TD]
[TD]137[/TD]
[TD]SW452[/TD]
[TD]BWI[/TD]
[TD]700[/TD]
[TD]137[/TD]
[TD]SW452[/TD]
[TD]BWI[/TD]
[TD]700[/TD]
[TD]137[/TD]
[TD]SW452[/TD]
[TD]BWI[/TD]
[TD]700[/TD]
[TD]137[/TD]
[TD]SW452[/TD]
[TD]BWI[/TD]
[TD]700[/TD]
[TD]137[/TD]
[/TR]
[TR]
[TD]SW3850[/TD]
[TD]TPA[/TD]
[TD]800[/TD]
[TD]143[/TD]
[TD]SW1092[/TD]
[TD]BWI[/TD]
[TD]400[/TD]
[TD]175[/TD]
[TD]SW1092[/TD]
[TD]BWI[/TD]
[TD]400[/TD]
[TD]175[/TD]
[TD]SW1092[/TD]
[TD]BWI[/TD]
[TD]400[/TD]
[TD]175[/TD]
[TD]SW1092[/TD]
[TD]BWI[/TD]
[TD]400[/TD]
[TD]175[/TD]
[TD]SW1092[/TD]
[TD]BWI[/TD]
[TD]400[/TD]
[TD]175[/TD]
[/TR]
[TR]
[TD]SW802[/TD]
[TD]MDW[/TD]
[TD]1750[/TD]
[TD]175[/TD]
[TD]SW767[/TD]
[TD]BWI[/TD]
[TD]500[/TD]
[TD]143[/TD]
[TD]SW767[/TD]
[TD]BWI[/TD]
[TD]500[/TD]
[TD]143[/TD]
[TD]SW767[/TD]
[TD]BWI[/TD]
[TD]500[/TD]
[TD]143[/TD]
[TD]SW767[/TD]
[TD]BWI[/TD]
[TD]500[/TD]
[TD]143[/TD]
[TD]SW767[/TD]
[TD]BWI[/TD]
[TD]500[/TD]
[TD]143[/TD]
[/TR]
[TR]
[TD]SW2513[/TD]
[TD]BWI[/TD]
[TD]1215[/TD]
[TD]143[/TD]
[TD]SW3850[/TD]
[TD]TPA[/TD]
[TD]800[/TD]
[TD]143[/TD]
[TD]SW3850[/TD]
[TD]TPA[/TD]
[TD]800[/TD]
[TD]143[/TD]
[TD]SW3850[/TD]
[TD]TPA[/TD]
[TD]800[/TD]
[TD]143[/TD]
[TD]SW3850[/TD]
[TD]TPA[/TD]
[TD]800[/TD]
[TD]143[/TD]
[TD]SW3850[/TD]
[TD]TPA[/TD]
[TD]800[/TD]
[TD]143[/TD]
[/TR]
[TR]
[TD]SW1533[/TD]
[TD]BWI[/TD]
[TD]1450[/TD]
[TD]143[/TD]
[TD]SW802[/TD]
[TD]MDW[/TD]
[TD]1750[/TD]
[TD]175[/TD]
[TD]SW802[/TD]
[TD]MDW[/TD]
[TD]1750[/TD]
[TD]175[/TD]
[TD]SW802[/TD]
[TD]MDW[/TD]
[TD]1750[/TD]
[TD]175[/TD]
[TD]SW802[/TD]
[TD]MDW[/TD]
[TD]1750[/TD]
[TD]175[/TD]
[TD]SW802[/TD]
[TD]MDW[/TD]
[TD]1750[/TD]
[TD]175[/TD]
[/TR]
[TR]
[TD]SW302[/TD]
[TD]BWI[/TD]
[TD]1705[/TD]
[TD]143[/TD]
[TD]SW2513[/TD]
[TD]BWI[/TD]
[TD]1215[/TD]
[TD]143[/TD]
[TD]SW2513[/TD]
[TD]BWI[/TD]
[TD]1215[/TD]
[TD]143[/TD]
[TD]SW2513[/TD]
[TD]BWI[/TD]
[TD]1215[/TD]
[TD]143[/TD]
[TD]SW2513[/TD]
[TD]BWI[/TD]
[TD]1215[/TD]
[TD]143[/TD]
[TD]SW2513[/TD]
[TD]BWI[/TD]
[TD]1215[/TD]
[TD]143[/TD]
[/TR]
[TR]
[TD]SW750[/TD]
[TD]MDW[/TD]
[TD]1400[/TD]
[TD]175[/TD]
[TD]SW1533[/TD]
[TD]BWI[/TD]
[TD]1450[/TD]
[TD]143[/TD]
[TD]SW1533[/TD]
[TD]BWI[/TD]
[TD]1450[/TD]
[TD]143[/TD]
[TD]SW1533[/TD]
[TD]BWI[/TD]
[TD]1450[/TD]
[TD]143[/TD]
[TD]SW1533[/TD]
[TD]BWI[/TD]
[TD]1450[/TD]
[TD]143[/TD]
[TD]SW1533[/TD]
[TD]BWI[/TD]
[TD]1450[/TD]
[TD]143[/TD]
[/TR]
[TR]
[TD]SW2222[/TD]
[TD]MDW[/TD]
[TD]1830[/TD]
[TD]175[/TD]
[TD]SW302[/TD]
[TD]BWI[/TD]
[TD]1705[/TD]
[TD]143[/TD]
[TD]SW302[/TD]
[TD]BWI[/TD]
[TD]1705[/TD]
[TD]143[/TD]
[TD]SW302[/TD]
[TD]BWI[/TD]
[TD]1705[/TD]
[TD]143[/TD]
[TD]SW302[/TD]
[TD]BWI[/TD]
[TD]1705[/TD]
[TD]143[/TD]
[TD]SW302[/TD]
[TD]BWI[/TD]
[TD]1705[/TD]
[TD]143[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]SW750[/TD]
[TD]MDW[/TD]
[TD]1400[/TD]
[TD]175[/TD]
[TD]SW750[/TD]
[TD]MDW[/TD]
[TD]1400[/TD]
[TD]175[/TD]
[TD]SW750[/TD]
[TD]MDW[/TD]
[TD]1400[/TD]
[TD]175[/TD]
[TD]SW750[/TD]
[TD]MDW[/TD]
[TD]1400[/TD]
[TD]175[/TD]
[TD]SW750[/TD]
[TD]MDW[/TD]
[TD]1400[/TD]
[TD]175[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]SW2222[/TD]
[TD]MDW[/TD]
[TD]1830[/TD]
[TD]175[/TD]
[TD]SW2222[/TD]
[TD]MDW[/TD]
[TD]1830[/TD]
[TD]175[/TD]
[TD]SW2222[/TD]
[TD]MDW[/TD]
[TD]1830[/TD]
[TD]175[/TD]
[TD]SW2222[/TD]
[TD]MDW[/TD]
[TD]1830[/TD]
[TD]175[/TD]
[TD]SW2222[/TD]
[TD]MDW[/TD]
[TD]1830[/TD]
[TD]175[/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]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DL8989[/TD]
[TD]ATL[/TD]
[TD]800[/TD]
[TD]50[/TD]
[TD]DL8989[/TD]
[TD]ATL[/TD]
[TD]800[/TD]
[TD]50[/TD]
[TD]DL8989[/TD]
[TD]ATL[/TD]
[TD]800[/TD]
[TD]50[/TD]
[TD]DL8989[/TD]
[TD]ATL[/TD]
[TD]800[/TD]
[TD]50[/TD]
[TD]DL8989[/TD]
[TD]ATL[/TD]
[TD]800[/TD]
[TD]50[/TD]
[TD]DL8989[/TD]
[TD]ATL[/TD]
[TD]800[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]DL1234[/TD]
[TD]DTW[/TD]
[TD]1200[/TD]
[TD]60[/TD]
[TD]DL1234[/TD]
[TD]DTW[/TD]
[TD]1200[/TD]
[TD]60[/TD]
[TD]DL1234[/TD]
[TD]DTW[/TD]
[TD]1200[/TD]
[TD]60[/TD]
[TD]DL1234[/TD]
[TD]DTW[/TD]
[TD]1200[/TD]
[TD]60[/TD]
[TD]DL1234[/TD]
[TD]DTW[/TD]
[TD]1200[/TD]
[TD]60[/TD]
[TD]DL1234[/TD]
[TD]DTW[/TD]
[TD]1200[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]DL4321[/TD]
[TD]LGA[/TD]
[TD]400[/TD]
[TD]50[/TD]
[TD]DL4321[/TD]
[TD]LGA[/TD]
[TD]400[/TD]
[TD]40[/TD]
[TD]DL4321[/TD]
[TD]LGA[/TD]
[TD]400[/TD]
[TD]40[/TD]
[TD]DL4321[/TD]
[TD]LGA[/TD]
[TD]400[/TD]
[TD]40[/TD]
[TD]DL4321[/TD]
[TD]LGA[/TD]
[TD]400[/TD]
[TD]40[/TD]
[TD]DL4321[/TD]
[TD]LGA[/TD]
[TD]400[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]DL4566[/TD]
[TD]DTW[/TD]
[TD]300[/TD]
[TD]80[/TD]
[TD]DL4566[/TD]
[TD]DTW[/TD]
[TD]300[/TD]
[TD]75[/TD]
[TD]DL4566[/TD]
[TD]DTW[/TD]
[TD]300[/TD]
[TD]75[/TD]
[TD]DL4566[/TD]
[TD]DTW[/TD]
[TD]300[/TD]
[TD]75[/TD]
[TD]DL4566[/TD]
[TD]DTW[/TD]
[TD]300[/TD]
[TD]75[/TD]
[TD]DL4566[/TD]
[TD]DTW[/TD]
[TD]300[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD]DL3333[/TD]
[TD]ATL[/TD]
[TD]600[/TD]
[TD]100[/TD]
[TD]DL3333[/TD]
[TD]ATL[/TD]
[TD]600[/TD]
[TD]100[/TD]
[TD]DL3333[/TD]
[TD]ATL[/TD]
[TD]600[/TD]
[TD]100[/TD]
[TD]DL3333[/TD]
[TD]ATL[/TD]
[TD]600[/TD]
[TD]100[/TD]
[TD]DL3333[/TD]
[TD]ATL[/TD]
[TD]600[/TD]
[TD]100[/TD]
[TD]DL3333[/TD]
[TD]ATL[/TD]
[TD]600[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]DL2145[/TD]
[TD]LGA[/TD]
[TD]700[/TD]
[TD]68[/TD]
[TD]DL2145[/TD]
[TD]LGA[/TD]
[TD]700[/TD]
[TD]68[/TD]
[TD]DL2145[/TD]
[TD]LGA[/TD]
[TD]700[/TD]
[TD]68[/TD]
[TD]DL2145[/TD]
[TD]LGA[/TD]
[TD]700[/TD]
[TD]68[/TD]
[TD]DL2145[/TD]
[TD]LGA[/TD]
[TD]700[/TD]
[TD]68[/TD]
[TD]DL2145[/TD]
[TD]LGA[/TD]
[TD]700[/TD]
[TD]68[/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]
[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]
[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]
[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]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]UA4567[/TD]
[TD]EWR[/TD]
[TD]1400[/TD]
[TD]50[/TD]
[TD]UA4567[/TD]
[TD]EWR[/TD]
[TD]1400[/TD]
[TD]50[/TD]
[TD]UA4567[/TD]
[TD]EWR[/TD]
[TD]1400[/TD]
[TD]50[/TD]
[TD]UA4567[/TD]
[TD]EWR[/TD]
[TD]1400[/TD]
[TD]50[/TD]
[TD]UA4567[/TD]
[TD]EWR[/TD]
[TD]1400[/TD]
[TD]50[/TD]
[TD]UA4567[/TD]
[TD]EWR[/TD]
[TD]1400[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]UA6109[/TD]
[TD]ORD[/TD]
[TD]1300[/TD]
[TD]50[/TD]
[TD]UA6109[/TD]
[TD]ORD[/TD]
[TD]1300[/TD]
[TD]60[/TD]
[TD]UA6109[/TD]
[TD]ORD[/TD]
[TD]1300[/TD]
[TD]60[/TD]
[TD]UA6109[/TD]
[TD]ORD[/TD]
[TD]1300[/TD]
[TD]60[/TD]
[TD]UA6109[/TD]
[TD]ORD[/TD]
[TD]1300[/TD]
[TD]60[/TD]
[TD]UA6109[/TD]
[TD]ORD[/TD]
[TD]1300[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]UA5955[/TD]
[TD]EWR[/TD]
[TD]1200[/TD]
[TD]60[/TD]
[TD]UA5955[/TD]
[TD]EWR[/TD]
[TD]1200[/TD]
[TD]60[/TD]
[TD]UA5955[/TD]
[TD]EWR[/TD]
[TD]1200[/TD]
[TD]60[/TD]
[TD]UA5955[/TD]
[TD]EWR[/TD]
[TD]1200[/TD]
[TD]60[/TD]
[TD]UA5955[/TD]
[TD]EWR[/TD]
[TD]1200[/TD]
[TD]60[/TD]
[TD]UA5955[/TD]
[TD]EWR[/TD]
[TD]1200[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]UA4328[/TD]
[TD]ORD[/TD]
[TD]800[/TD]
[TD]60[/TD]
[TD]UA4328[/TD]
[TD]ORD[/TD]
[TD]800[/TD]
[TD]60[/TD]
[TD]UA4328[/TD]
[TD]ORD[/TD]
[TD]800[/TD]
[TD]60[/TD]
[TD]UA4328[/TD]
[TD]ORD[/TD]
[TD]800[/TD]
[TD]60[/TD]
[TD]UA4328[/TD]
[TD]ORD[/TD]
[TD]800[/TD]
[TD]60[/TD]
[TD]UA4328[/TD]
[TD]ORD[/TD]
[TD]800[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]UA3834[/TD]
[TD]EWR[/TD]
[TD]700[/TD]
[TD]75[/TD]
[TD]UA3834[/TD]
[TD]EWR[/TD]
[TD]700[/TD]
[TD]75[/TD]
[TD]UA3834[/TD]
[TD]EWR[/TD]
[TD]700[/TD]
[TD]75[/TD]
[TD]UA3834[/TD]
[TD]EWR[/TD]
[TD]700[/TD]
[TD]75[/TD]
[TD]UA3834[/TD]
[TD]EWR[/TD]
[TD]700[/TD]
[TD]75[/TD]
[TD]UA3834[/TD]
[TD]EWR[/TD]
[TD]700[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD]UA4625[/TD]
[TD]CLT[/TD]
[TD]1700[/TD]
[TD]75[/TD]
[TD]UA4625[/TD]
[TD]CLT[/TD]
[TD]1700[/TD]
[TD]75[/TD]
[TD]UA4625[/TD]
[TD]CLT[/TD]
[TD]1700[/TD]
[TD]75[/TD]
[TD]UA4625[/TD]
[TD]CLT[/TD]
[TD]1700[/TD]
[TD]75[/TD]
[TD]UA4625[/TD]
[TD]CLT[/TD]
[TD]1700[/TD]
[TD]75[/TD]
[TD]UA4625[/TD]
[TD]CLT[/TD]
[TD]1700[/TD]
[TD]75[/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]
[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]
[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]
[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]
[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]
[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]
[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]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Totals:[/TD]
[TD][/TD]
[TD][/TD]
[TD]3216[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3211[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3211[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3211[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3211[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3211[/TD]
[/TR]
</tbody>[/TABLE]
 
It would be much easier if you put all of the data in a single table: A/L, flight, dest, date/time, and captain. Then you could sort and report to your heart's content.
 
Upvote 0

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Sorted by date, airline, and time:

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]
A​
[/td][td]
B​
[/td][td]
C​
[/td][td]
D​
[/td][td]
E​
[/td][td]
F​
[/td][/tr][tr][td]
1​
[/td][td]
Date
[/td][td]
Time
[/td][td]
A/L
[/td][td]
Flt
[/td][td]
Dest
[/td][td]
Capt
[/td][/tr]
[tr][td]
2​
[/td][td]
2016-09-01​
[/td][td]
3:00​
[/td][td]DL[/td][td]
4566​
[/td][td]DTW[/td][td]
80​
[/td][/tr]
[tr][td]
3​
[/td][td]
2016-09-01​
[/td][td]
4:00​
[/td][td]DL[/td][td]
4321​
[/td][td]LGA[/td][td]
50​
[/td][/tr]
[tr][td]
4​
[/td][td]
2016-09-01​
[/td][td]
6:00​
[/td][td]DL[/td][td]
3333​
[/td][td]ATL[/td][td]
100​
[/td][/tr]
[tr][td]
5​
[/td][td]
2016-09-01​
[/td][td]
7:00​
[/td][td]DL[/td][td]
2145​
[/td][td]LGA[/td][td]
68​
[/td][/tr]
[tr][td]
6​
[/td][td]
2016-09-01​
[/td][td]
8:00​
[/td][td]DL[/td][td]
8989​
[/td][td]ATL[/td][td]
50​
[/td][/tr]
[tr][td]
7​
[/td][td]
2016-09-01​
[/td][td]
12:00​
[/td][td]DL[/td][td]
1234​
[/td][td]DTW[/td][td]
60​
[/td][/tr]
[tr][td]
8​
[/td][td]
2016-09-01​
[/td][td]
4:00​
[/td][td]SW[/td][td]
1092​
[/td][td]BWI[/td][td]
175​
[/td][/tr]
[tr][td]
9​
[/td][td]
2016-09-01​
[/td][td]
5:00​
[/td][td]SW[/td][td]
767​
[/td][td]BWI[/td][td]
143​
[/td][/tr]
[tr][td]
10​
[/td][td]
2016-09-01​
[/td][td]
5:30​
[/td][td]SW[/td][td]
1270​
[/td][td]MDW[/td][td]
175​
[/td][/tr]
[tr][td]
11​
[/td][td]
2016-09-01​
[/td][td]
5:55​
[/td][td]SW[/td][td]
647​
[/td][td]BWI[/td][td]
143​
[/td][/tr]
[tr][td]
12​
[/td][td]
2016-09-01​
[/td][td]
6:05​
[/td][td]SW[/td][td]
1537​
[/td][td]MCO[/td][td]
143​
[/td][/tr]
[tr][td]
13​
[/td][td]
2016-09-01​
[/td][td]
7:00​
[/td][td]SW[/td][td]
452​
[/td][td]BWI[/td][td]
137​
[/td][/tr]
[tr][td]
14​
[/td][td]
2016-09-01​
[/td][td]
8:00​
[/td][td]SW[/td][td]
3850​
[/td][td]TPA[/td][td]
143​
[/td][/tr]
[tr][td]
15​
[/td][td]
2016-09-01​
[/td][td]
12:15​
[/td][td]SW[/td][td]
2513​
[/td][td]BWI[/td][td]
143​
[/td][/tr]
[tr][td]
16​
[/td][td]
2016-09-01​
[/td][td]
14:00​
[/td][td]SW[/td][td]
750​
[/td][td]MDW[/td][td]
175​
[/td][/tr]
[tr][td]
17​
[/td][td]
2016-09-01​
[/td][td]
14:50​
[/td][td]SW[/td][td]
1533​
[/td][td]BWI[/td][td]
143​
[/td][/tr]
[tr][td]
18​
[/td][td]
2016-09-01​
[/td][td]
17:05​
[/td][td]SW[/td][td]
302​
[/td][td]BWI[/td][td]
143​
[/td][/tr]
[tr][td]
19​
[/td][td]
2016-09-01​
[/td][td]
17:50​
[/td][td]SW[/td][td]
802​
[/td][td]MDW[/td][td]
175​
[/td][/tr]
[tr][td]
20​
[/td][td]
2016-09-01​
[/td][td]
18:30​
[/td][td]SW[/td][td]
2222​
[/td][td]MDW[/td][td]
175​
[/td][/tr]
[tr][td]
21​
[/td][td]
2016-09-01​
[/td][td]
7:00​
[/td][td]UA[/td][td]
3834​
[/td][td]EWR[/td][td]
75​
[/td][/tr]
[tr][td]
22​
[/td][td]
2016-09-01​
[/td][td]
8:00​
[/td][td]UA[/td][td]
4328​
[/td][td]ORD[/td][td]
60​
[/td][/tr]
[tr][td]
23​
[/td][td]
2016-09-01​
[/td][td]
12:00​
[/td][td]UA[/td][td]
5955​
[/td][td]EWR[/td][td]
60​
[/td][/tr]
[tr][td]
24​
[/td][td]
2016-09-01​
[/td][td]
13:00​
[/td][td]UA[/td][td]
6109​
[/td][td]ORD[/td][td]
50​
[/td][/tr]
[tr][td]
25​
[/td][td]
2016-09-01​
[/td][td]
14:00​
[/td][td]UA[/td][td]
4567​
[/td][td]EWR[/td][td]
50​
[/td][/tr]
[tr][td]
26​
[/td][td]
2016-09-01​
[/td][td]
17:00​
[/td][td]UA[/td][td]
4625​
[/td][td]CLT[/td][td]
75​
[/td][/tr]
[tr][td]
27​
[/td][td]
2016-09-01​
[/td][td]
7:00​
[/td][td]US[/td][td]
3775​
[/td][td]DCA[/td][td]
45​
[/td][/tr]
[tr][td]
28​
[/td][td]
2016-09-01​
[/td][td]
8:00​
[/td][td]US[/td][td]
4082​
[/td][td]PHL[/td][td]
100​
[/td][/tr]
[tr][td]
29​
[/td][td]
2016-09-01​
[/td][td]
12:00​
[/td][td]US[/td][td]
4465​
[/td][td]CLT[/td][td]
80​
[/td][/tr]
[tr][td]
30​
[/td][td]
2016-09-01​
[/td][td]
14:00​
[/td][td]US[/td][td]
3827​
[/td][td]PHL[/td][td]
75​
[/td][/tr]
[tr][td]
31​
[/td][td]
2016-09-01​
[/td][td]
15:00​
[/td][td]US[/td][td]
4472​
[/td][td]PHL[/td][td]
50​
[/td][/tr]
[tr][td]
32​
[/td][td]
2016-09-01​
[/td][td]
18:00​
[/td][td]US[/td][td]
4577​
[/td][td]DCA[/td][td]
75​
[/td][/tr]
[tr][td]
33​
[/td][td]
2016-09-02​
[/td][td]
3:00​
[/td][td]DL[/td][td]
4566​
[/td][td]DTW[/td][td]
75​
[/td][/tr]
[tr][td]
34​
[/td][td]
2016-09-02​
[/td][td]
4:00​
[/td][td]DL[/td][td]
4321​
[/td][td]LGA[/td][td]
40​
[/td][/tr]
[tr][td]
35​
[/td][td]
2016-09-02​
[/td][td]
6:00​
[/td][td]DL[/td][td]
3333​
[/td][td]ATL[/td][td]
100​
[/td][/tr]
[tr][td]
36​
[/td][td]
2016-09-02​
[/td][td]
7:00​
[/td][td]DL[/td][td]
2145​
[/td][td]LGA[/td][td]
68​
[/td][/tr]
[tr][td]
37​
[/td][td]
2016-09-02​
[/td][td]
8:00​
[/td][td]DL[/td][td]
8989​
[/td][td]ATL[/td][td]
50​
[/td][/tr]
[tr][td]
38​
[/td][td]
2016-09-02​
[/td][td]
12:00​
[/td][td]DL[/td][td]
1234​
[/td][td]DTW[/td][td]
60​
[/td][/tr]
[tr][td]
39​
[/td][td]
2016-09-02​
[/td][td]
4:00​
[/td][td]SW[/td][td]
1092​
[/td][td]BWI[/td][td]
175​
[/td][/tr]
[tr][td]
40​
[/td][td]
2016-09-02​
[/td][td]
5:00​
[/td][td]SW[/td][td]
767​
[/td][td]BWI[/td][td]
143​
[/td][/tr]
[tr][td]
41​
[/td][td]
2016-09-02​
[/td][td]
5:30​
[/td][td]SW[/td][td]
1270​
[/td][td]MDW[/td][td]
175​
[/td][/tr]
[tr][td]
42​
[/td][td]
2016-09-02​
[/td][td]
5:55​
[/td][td]SW[/td][td]
647​
[/td][td]BWI[/td][td]
143​
[/td][/tr]
[tr][td]
43​
[/td][td]
2016-09-02​
[/td][td]
6:05​
[/td][td]SW[/td][td]
1537​
[/td][td]MCO[/td][td]
143​
[/td][/tr]
[tr][td]
44​
[/td][td]
2016-09-02​
[/td][td]
7:00​
[/td][td]SW[/td][td]
452​
[/td][td]BWI[/td][td]
137​
[/td][/tr]
[tr][td]
45​
[/td][td]
2016-09-02​
[/td][td]
8:00​
[/td][td]SW[/td][td]
3850​
[/td][td]TPA[/td][td]
143​
[/td][/tr]
[tr][td]
46​
[/td][td]
2016-09-02​
[/td][td]
12:15​
[/td][td]SW[/td][td]
2513​
[/td][td]BWI[/td][td]
143​
[/td][/tr]
[tr][td]
47​
[/td][td]
2016-09-02​
[/td][td]
14:00​
[/td][td]SW[/td][td]
750​
[/td][td]MDW[/td][td]
175​
[/td][/tr]
[tr][td]
48​
[/td][td]
2016-09-02​
[/td][td]
14:50​
[/td][td]SW[/td][td]
1533​
[/td][td]BWI[/td][td]
143​
[/td][/tr]
[tr][td]
49​
[/td][td]
2016-09-02​
[/td][td]
17:05​
[/td][td]SW[/td][td]
302​
[/td][td]BWI[/td][td]
143​
[/td][/tr]
[tr][td]
50​
[/td][td]
2016-09-02​
[/td][td]
17:50​
[/td][td]SW[/td][td]
802​
[/td][td]MDW[/td][td]
175​
[/td][/tr]
[tr][td]
51​
[/td][td]
2016-09-02​
[/td][td]
18:30​
[/td][td]SW[/td][td]
2222​
[/td][td]MDW[/td][td]
175​
[/td][/tr]
[tr][td]
52​
[/td][td]
2016-09-02​
[/td][td]
7:00​
[/td][td]UA[/td][td]
3834​
[/td][td]EWR[/td][td]
75​
[/td][/tr]
[tr][td]
53​
[/td][td]
2016-09-02​
[/td][td]
8:00​
[/td][td]UA[/td][td]
4328​
[/td][td]ORD[/td][td]
60​
[/td][/tr]
[tr][td]
54​
[/td][td]
2016-09-02​
[/td][td]
12:00​
[/td][td]UA[/td][td]
5955​
[/td][td]EWR[/td][td]
60​
[/td][/tr]
[tr][td]
55​
[/td][td]
2016-09-02​
[/td][td]
13:00​
[/td][td]UA[/td][td]
6109​
[/td][td]ORD[/td][td]
50​
[/td][/tr]
[tr][td]
56​
[/td][td]
2016-09-02​
[/td][td]
14:00​
[/td][td]UA[/td][td]
4567​
[/td][td]EWR[/td][td]
50​
[/td][/tr]
[tr][td]
57​
[/td][td]
2016-09-02​
[/td][td]
17:00​
[/td][td]UA[/td][td]
4625​
[/td][td]CLT[/td][td]
75​
[/td][/tr]
[tr][td]
58​
[/td][td]
2016-09-02​
[/td][td]
7:00​
[/td][td]US[/td][td]
3775​
[/td][td]DCA[/td][td]
45​
[/td][/tr]
[tr][td]
59​
[/td][td]
2016-09-02​
[/td][td]
8:00​
[/td][td]US[/td][td]
4082​
[/td][td]PHL[/td][td]
100​
[/td][/tr]
[tr][td]
60​
[/td][td]
2016-09-02​
[/td][td]
12:00​
[/td][td]US[/td][td]
4465​
[/td][td]CLT[/td][td]
80​
[/td][/tr]
[tr][td]
61​
[/td][td]
2016-09-02​
[/td][td]
14:00​
[/td][td]US[/td][td]
3827​
[/td][td]PHL[/td][td]
75​
[/td][/tr]
[tr][td]
62​
[/td][td]
2016-09-02​
[/td][td]
15:00​
[/td][td]US[/td][td]
4472​
[/td][td]PHL[/td][td]
50​
[/td][/tr]
[tr][td]
63​
[/td][td]
2016-09-02​
[/td][td]
18:00​
[/td][td]US[/td][td]
4577​
[/td][td]DCA[/td][td]
75​
[/td][/tr]
[/table]
 
Last edited:
Upvote 0
Randy,

What shg mentions is worth a consideration if your report gets any more complex.
A single list is MUCH more flexible to maintain, sort, filter and report on. As a matter of fact, you could generate any format of report and output it in a number of different summarized ways very quickly by using Pivot Tables.

I know you have the macro functioning perfectly now, but for future reference, shg's advice is definitely valid and I concur (if your data is to become more complex).

Cheers
 
Upvote 0
I use pivot tables from a different source to validate my data. This "thing" that I have created is the first step in a process. There are other sheets that "pull" from this one and a certain format is needed. In fact the pivot table looks very much like what I have. There is so much that relies on what I have made first.
 
Upvote 0
I do have one other question though, what if at some later date I want to reduce the number of row in each date block to say 40 or some other number, what do I change in the code?
 
Upvote 0
It would be the first For statement and the Resize statement...

For r = 3 To 273 Step 54
You will need to change the 273 to the last row number with dates, and also the Step increment to something like 40.

With Cells(r, c).Resize(51, 4)
The resize determines the amount of rows in each date block. The 51 would have to change to 40 (or similar)

You will need to experiment with those numbers to determine the correct resizing.

NOTE: Whatever resizing you do: All the date blocks must remain the same size in column and row. The code is dependent on that!
 
Upvote 0
It would be the first For statement and the Resize statement...

For r = 3 To 273 Step 54
You will need to change the 273 to the last row number with dates, and also the Step increment to something like 40.

With Cells(r, c).Resize(51, 4)
The resize determines the amount of rows in each date block. The 51 would have to change to 40 (or similar)

You will need to experiment with those numbers to determine the correct resizing.

NOTE: Whatever resizing you do: All the date blocks must remain the same size in column and row. The code is dependent on that!

Interesting, I see the 3 and 273, those are where my "headers" start and end. The "step" 54 doesn't make any sense to me!!! The 51 is weird because I have 50 rows where actual data could go in each block. I'm guessing the 4 is the number of columns in each date block. R and C I'm sure mean Rows and Columns.
 
Last edited:
Upvote 0
In more detail:

The loop works within a date block; starting at the title Airline (row 3) and ending on the row just above the totals. So the first date block that the loop works in is: A3:D53. This is 51 rows by 4 columns.

The step in the loop is 54 as it has to jump over three lines to get to the block below it and start again in the Airline Cell. The three rows to jump over is the total in row A54, then blank row as block separater (A55) and the merged date cell (A56). So basically it is jumping from Airline, vertically down to the next Airline (54 rows between).

You have 50 rows for data, but the title is included in the loop for sorting purposes...51 rows.

4 is for the four columns and R and C are variables for row and column.

Hope this clarifies....
 
Upvote 0

Forum statistics

Threads
1,223,996
Messages
6,175,862
Members
452,676
Latest member
woodyp

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