insert row at truck plate number

[makinmomb]

I have the following data

[TABLE="width: 1171"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]MON[/TD]
[TD]JOB NO[/TD]
[TD]CLIENT[/TD]
[TD]CONTAINER[/TD]
[TD]W[/TD]
[TD]C[/TD]
[TD]DESTINATION[/TD]
[TD]TRUCK[/TD]
[TD]TRAIL[/TD]
[TD]DRIVER[/TD]
[TD]TRANS[/TD]
[TD]DATE[/TD]
[TD]SV 0[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]TR-0288-18[/TD]
[TD]TSHUMA MUNINGA ALEX [/TD]
[TD]MRKU4484340[/TD]
[TD]17.8[/TD]
[TD]40[/TD]
[TD]LUBUMBASHI [/TD]
[TD]T432DCC[/TD]
[TD]T316BGZ[/TD]
[TD]OMARY BAKARI OMARY [/TD]
[TD]AQUARIUS [/TD]
[TD]1-May-18[/TD]
[TD="align: right"]502500[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]TR-0278-18[/TD]
[TD]BELTEXCO SARL[/TD]
[TD]MSKU2177644[/TD]
[TD]27.9[/TD]
[TD]20[/TD]
[TD]LUBUMBASHI [/TD]
[TD]T356CTX[/TD]
[TD]T250AXM[/TD]
[TD]TIZZO MOHAMMED ATHUMANI [/TD]
[TD]AQUARIUS [/TD]
[TD]1-May-18[/TD]
[TD="align: right"]823000[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]TR-0278-18[/TD]
[TD]BELTEXCO SARL[/TD]
[TD]MSKU3468813[/TD]
[TD]26.4[/TD]
[TD]20[/TD]
[TD]LUBUMBASHI [/TD]
[TD]T271BUK[/TD]
[TD]T854DDD[/TD]
[TD]OMARY KHAMISI MPASANJE [/TD]
[TD]AQUARIUS [/TD]
[TD]1-May-18[/TD]
[TD="align: right"]1421500[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]TR-0322-18[/TD]
[TD]SOBI INDUSTRIES LTD[/TD]
[TD]CMAU7071905[/TD]
[TD]28T[/TD]
[TD]40[/TD]
[TD]LUSAKA [/TD]
[TD]T239DEZ[/TD]
[TD]T964BHP[/TD]
[TD]BAKARI SAIDI BWANARI [/TD]
[TD]AQUARIUS [/TD]
[TD]1-May-18[/TD]
[TD="align: right"]166000[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]TR-0271-18[/TD]
[TD]GOUROCK ZAMBIA LTD [/TD]
[TD]DFSU1088540[/TD]
[TD]26.2[/TD]
[TD]20[/TD]
[TD]NDOLA [/TD]
[TD]T454CZS[/TD]
[TD]T193DAR [/TD]
[TD]KHALFAN ABDALLAH URARI [/TD]
[TD]AQUARIUS [/TD]
[TD]1-May-18[/TD]
[TD="align: right"]2554000[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]TR-0308-18[/TD]
[TD]NR INVESTMENT [/TD]
[TD]CXDU2101006[/TD]
[TD]27.8[/TD]
[TD]20[/TD]
[TD]LUSAKA [/TD]
[TD]T690BKE[/TD]
[TD]T850CYN[/TD]
[TD]VICENT ROSHENY MLENGA [/TD]
[TD]AQUARIUS [/TD]
[TD]1-May-18[/TD]
[TD="align: right"]1127500[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]TR-0429-18[/TD]
[TD]OM METAL RESOURCES SARL[/TD]
[TD]MSKU963607[/TD]
[TD]25.6[/TD]
[TD]40[/TD]
[TD]LUBUMBASHI[/TD]
[TD]T432DCC[/TD]
[TD]T316BGZ[/TD]
[TD]OMARY BAKARI OMARY [/TD]
[TD]AQUARIUS [/TD]
[TD]6-Jun-18[/TD]
[TD="align: right"]1337900[/TD]
[/TR]
</tbody>[/TABLE]

 

[makinmomb]

I need macro to filter row h by plate number , then insert row from one truck to another

 

[makinmomb]

If it does the how I want it , it should give following results

[TABLE="width: 1171"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]MON[/TD]
[TD]JOB NO[/TD]
[TD]CLIENT[/TD]
[TD]CONTAINER[/TD]
[TD]W[/TD]
[TD]C[/TD]
[TD]DESTINATION[/TD]
[TD]TRUCK[/TD]
[TD]TRAIL[/TD]
[TD]DRIVER[/TD]
[TD]TRANS[/TD]
[TD]DATE[/TD]
[TD]SV 0[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]TR-0322-18[/TD]
[TD]SOBI INDUSTRIES LTD[/TD]
[TD]CMAU7071905[/TD]
[TD]28T[/TD]
[TD]40[/TD]
[TD]LUSAKA [/TD]
[TD]T239DEZ[/TD]
[TD]T964BHP[/TD]
[TD]BAKARI SAIDI BWANARI [/TD]
[TD]AQUARIUS [/TD]
[TD]1-May-18[/TD]
[TD="align: right"]166000[/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]
[/TR]
[TR]
[TD]5[/TD]
[TD]TR-0278-18[/TD]
[TD]BELTEXCO SARL[/TD]
[TD]MSKU3468813[/TD]
[TD]26.4[/TD]
[TD]20[/TD]
[TD]LUBUMBASHI [/TD]
[TD]T271BUK[/TD]
[TD]T854DDD[/TD]
[TD]OMARY KHAMISI MPASANJE [/TD]
[TD]AQUARIUS [/TD]
[TD]1-May-18[/TD]
[TD="align: right"]1421500[/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]
[/TR]
[TR]
[TD]5[/TD]
[TD]TR-0278-18[/TD]
[TD]BELTEXCO SARL[/TD]
[TD]MSKU2177644[/TD]
[TD]27.9[/TD]
[TD]20[/TD]
[TD]LUBUMBASHI [/TD]
[TD]T356CTX[/TD]
[TD]T250AXM[/TD]
[TD]TIZZO MOHAMMED ATHUMANI [/TD]
[TD]AQUARIUS [/TD]
[TD]1-May-18[/TD]
[TD="align: right"]823000[/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]
[/TR]
[TR]
[TD]5[/TD]
[TD]TR-0288-18[/TD]
[TD]TSHUMA MUNINGA ALEX [/TD]
[TD]MRKU4484340[/TD]
[TD]17.8[/TD]
[TD]40[/TD]
[TD]LUBUMBASHI [/TD]
[TD]T432DCC[/TD]
[TD]T316BGZ[/TD]
[TD]OMARY BAKARI OMARY [/TD]
[TD]AQUARIUS [/TD]
[TD]1-May-18[/TD]
[TD="align: right"]502500[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]TR-0429-18[/TD]
[TD]OM METAL RESOURCES SARL[/TD]
[TD]MSKU963607[/TD]
[TD]25.6[/TD]
[TD]40[/TD]
[TD]LUBUMBASHI[/TD]
[TD]T432DCC[/TD]
[TD]T316BGZ[/TD]
[TD]OMARY BAKARI OMARY [/TD]
[TD]AQUARIUS [/TD]
[TD]6-Jun-18[/TD]
[TD="align: right"]1337900[/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]
[/TR]
[TR]
[TD]5[/TD]
[TD]TR-0271-18[/TD]
[TD]GOUROCK ZAMBIA LTD [/TD]
[TD]DFSU1088540[/TD]
[TD]26.2[/TD]
[TD]20[/TD]
[TD]NDOLA [/TD]
[TD]T454CZS[/TD]
[TD]T193DAR [/TD]
[TD]KHALFAN ABDALLAH URARI [/TD]
[TD]AQUARIUS [/TD]
[TD]1-May-18[/TD]
[TD="align: right"]2554000[/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]
[/TR]
[TR]
[TD]5[/TD]
[TD]TR-0308-18[/TD]
[TD]NR INVESTMENT [/TD]
[TD]CXDU2101006[/TD]
[TD]27.8[/TD]
[TD]20[/TD]
[TD]LUSAKA [/TD]
[TD]T690BKE[/TD]
[TD]T850CYN[/TD]
[TD]VICENT ROSHENY MLENGA [/TD]
[TD]AQUARIUS [/TD]
[TD]1-May-18[/TD]
[TD="align: right"]1127500[/TD]
[/TR]
</tbody>[/TABLE]

 

[makinmomb]

I should be able to see this truck as done two trips seperated by rows with other data that have one trip

[TABLE="width: 1171"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]5[/TD]
[TD]TR-0288-18[/TD]
[TD]TSHUMA MUNINGA ALEX [/TD]
[TD]MRKU4484340[/TD]
[TD]17.8[/TD]
[TD]40[/TD]
[TD]LUBUMBASHI [/TD]
[TD]T432DCC[/TD]
[TD]T316BGZ[/TD]
[TD]OMARY BAKARI OMARY [/TD]
[TD]AQUARIUS [/TD]
[TD]1-May-18[/TD]
[TD="align: right"]502500[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]TR-0429-18[/TD]
[TD]OM METAL RESOURCES SARL[/TD]
[TD]MSKU963607[/TD]
[TD]25.6[/TD]
[TD]40[/TD]
[TD]LUBUMBASHI[/TD]
[TD]T432DCC[/TD]
[TD]T316BGZ[/TD]
[TD]OMARY BAKARI OMARY [/TD]
[TD]AQUARIUS [/TD]
[TD]6-Jun-18[/TD]
[TD="align: right"]1337900[/TD]
[/TR]
</tbody>[/TABLE]

 

[makinmomb]

The macro should read range whole sheet as I am expected to paste data worth 4 months with like 200 plus trucks statistics

 

[makinmomb]

Maybe i should just wait dont wona do this manually

 

[makinmomb]

Re pulling thread for someone to see it again

 

[makinmomb]

Someone down there to help me on this i got too huge data , inserting rows will be more than punishment

 

[ali_zaheer]

Someone down there to help me on this i got too huge data , inserting rows will be more than punishment

you will have to sort the data by truck number then a code maybe added to auto insert row after each change in truck no. ok?

 

[makinmomb]

Sorting I will do , await the truck separator macro