insert row at truck plate number

makinmomb

Active Member
Joined
Dec 23, 2013
Messages
401
I have the following data

MONJOB NOCLIENTCONTAINERWCDESTINATIONTRUCKTRAILDRIVERTRANSDATESV 0
5TR-0288-18TSHUMA MUNINGA ALEX MRKU448434017.840LUBUMBASHI T432DCCT316BGZOMARY BAKARI OMARY AQUARIUS 1-May-18502500
5TR-0278-18BELTEXCO SARLMSKU217764427.920LUBUMBASHI T356CTXT250AXMTIZZO MOHAMMED ATHUMANI AQUARIUS 1-May-18823000
5TR-0278-18BELTEXCO SARLMSKU346881326.420LUBUMBASHI T271BUKT854DDDOMARY KHAMISI MPASANJE AQUARIUS 1-May-181421500
5TR-0322-18SOBI INDUSTRIES LTDCMAU707190528T40LUSAKA T239DEZT964BHPBAKARI SAIDI BWANARI AQUARIUS 1-May-18166000
5TR-0271-18GOUROCK ZAMBIA LTD DFSU108854026.220NDOLA T454CZST193DAR KHALFAN ABDALLAH URARI AQUARIUS 1-May-182554000
5TR-0308-18NR INVESTMENT CXDU210100627.820LUSAKA T690BKET850CYNVICENT ROSHENY MLENGA AQUARIUS 1-May-181127500
6TR-0429-18OM METAL RESOURCES SARLMSKU96360725.640LUBUMBASHIT432DCCT316BGZOMARY BAKARI OMARY AQUARIUS 6-Jun-181337900

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

makinmomb

Active Member
Joined
Dec 23, 2013
Messages
401
I need macro to filter row h by plate number , then insert row from one truck to another
 

makinmomb

Active Member
Joined
Dec 23, 2013
Messages
401
If it does the how I want it , it should give following results

MONJOB NOCLIENTCONTAINERWCDESTINATIONTRUCKTRAILDRIVERTRANSDATESV 0
5TR-0322-18SOBI INDUSTRIES LTDCMAU707190528T40LUSAKA T239DEZT964BHPBAKARI SAIDI BWANARI AQUARIUS 1-May-18166000
5TR-0278-18BELTEXCO SARLMSKU346881326.420LUBUMBASHI T271BUKT854DDDOMARY KHAMISI MPASANJE AQUARIUS 1-May-181421500
5TR-0278-18BELTEXCO SARLMSKU217764427.920LUBUMBASHI T356CTXT250AXMTIZZO MOHAMMED ATHUMANI AQUARIUS 1-May-18823000
5TR-0288-18TSHUMA MUNINGA ALEX MRKU448434017.840LUBUMBASHI T432DCCT316BGZOMARY BAKARI OMARY AQUARIUS 1-May-18502500
6TR-0429-18OM METAL RESOURCES SARLMSKU96360725.640LUBUMBASHIT432DCCT316BGZOMARY BAKARI OMARY AQUARIUS 6-Jun-181337900
5TR-0271-18GOUROCK ZAMBIA LTD DFSU108854026.220NDOLA T454CZST193DAR KHALFAN ABDALLAH URARI AQUARIUS 1-May-182554000
5TR-0308-18NR INVESTMENT CXDU210100627.820LUSAKA T690BKET850CYNVICENT ROSHENY MLENGA AQUARIUS 1-May-181127500

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
 

makinmomb

Active Member
Joined
Dec 23, 2013
Messages
401
I should be able to see this truck as done two trips seperated by rows with other data that have one trip

5TR-0288-18TSHUMA MUNINGA ALEX MRKU448434017.840LUBUMBASHI T432DCCT316BGZOMARY BAKARI OMARY AQUARIUS 1-May-18502500
6TR-0429-18OM METAL RESOURCES SARLMSKU96360725.640LUBUMBASHIT432DCCT316BGZOMARY BAKARI OMARY AQUARIUS 6-Jun-181337900

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
 

makinmomb

Active Member
Joined
Dec 23, 2013
Messages
401

ADVERTISEMENT

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

makinmomb

Active Member
Joined
Dec 23, 2013
Messages
401

ADVERTISEMENT

Re pulling thread for someone to see it again
 

makinmomb

Active Member
Joined
Dec 23, 2013
Messages
401
Someone down there to help me on this i got too huge data , inserting rows will be more than punishment
 

ali_zaheer

New Member
Joined
Oct 1, 2018
Messages
5
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,974
Messages
5,525,991
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top