insert row at truck plate number

[makinmomb]

I have the following data

MON

JOB NO

CLIENT

CONTAINER

W

C

DESTINATION

TRUCK

TRAIL

DRIVER

TRANS

DATE

SV 0

5

TR-0288-18

TSHUMA MUNINGA ALEX

MRKU4484340

17.8

40

LUBUMBASHI

T432DCC

T316BGZ

OMARY BAKARI OMARY

AQUARIUS

1-May-18

502500

5

TR-0278-18

BELTEXCO SARL

MSKU2177644

27.9

20

LUBUMBASHI

T356CTX

T250AXM

TIZZO MOHAMMED ATHUMANI

AQUARIUS

1-May-18

823000

5

TR-0278-18

BELTEXCO SARL

MSKU3468813

26.4

20

LUBUMBASHI

T271BUK

T854DDD

OMARY KHAMISI MPASANJE

AQUARIUS

1-May-18

1421500

5

TR-0322-18

SOBI INDUSTRIES LTD

CMAU7071905

28T

40

LUSAKA

T239DEZ

T964BHP

BAKARI SAIDI BWANARI

AQUARIUS

1-May-18

166000

5

TR-0271-18

GOUROCK ZAMBIA LTD

DFSU1088540

26.2

20

NDOLA

T454CZS

T193DAR

KHALFAN ABDALLAH URARI

AQUARIUS

1-May-18

2554000

5

TR-0308-18

NR INVESTMENT

CXDU2101006

27.8

20

LUSAKA

T690BKE

T850CYN

VICENT ROSHENY MLENGA

AQUARIUS

1-May-18

1127500

6

TR-0429-18

OM METAL RESOURCES SARL

MSKU963607

25.6

40

LUBUMBASHI

T432DCC

T316BGZ

OMARY BAKARI OMARY

AQUARIUS

6-Jun-18

1337900

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

 

[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

MON

JOB NO

CLIENT

CONTAINER

W

C

DESTINATION

TRUCK

TRAIL

DRIVER

TRANS

DATE

SV 0

5

TR-0322-18

SOBI INDUSTRIES LTD

CMAU7071905

28T

40

LUSAKA

T239DEZ

T964BHP

BAKARI SAIDI BWANARI

AQUARIUS

1-May-18

166000

5

TR-0278-18

BELTEXCO SARL

MSKU3468813

26.4

20

LUBUMBASHI

T271BUK

T854DDD

OMARY KHAMISI MPASANJE

AQUARIUS

1-May-18

1421500

5

TR-0278-18

BELTEXCO SARL

MSKU2177644

27.9

20

LUBUMBASHI

T356CTX

T250AXM

TIZZO MOHAMMED ATHUMANI

AQUARIUS

1-May-18

823000

5

TR-0288-18

TSHUMA MUNINGA ALEX

MRKU4484340

17.8

40

LUBUMBASHI

T432DCC

T316BGZ

OMARY BAKARI OMARY

AQUARIUS

1-May-18

502500

6

TR-0429-18

OM METAL RESOURCES SARL

MSKU963607

25.6

40

LUBUMBASHI

T432DCC

T316BGZ

OMARY BAKARI OMARY

AQUARIUS

6-Jun-18

1337900

5

TR-0271-18

GOUROCK ZAMBIA LTD

DFSU1088540

26.2

20

NDOLA

T454CZS

T193DAR

KHALFAN ABDALLAH URARI

AQUARIUS

1-May-18

2554000

5

TR-0308-18

NR INVESTMENT

CXDU2101006

27.8

20

LUSAKA

T690BKE

T850CYN

VICENT ROSHENY MLENGA

AQUARIUS

1-May-18

1127500

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

 

[makinmomb]

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

5

TR-0288-18

TSHUMA MUNINGA ALEX

MRKU4484340

17.8

40

LUBUMBASHI

T432DCC

T316BGZ

OMARY BAKARI OMARY

AQUARIUS

1-May-18

502500

6

TR-0429-18

OM METAL RESOURCES SARL

MSKU963607

25.6

40

LUBUMBASHI

T432DCC

T316BGZ

OMARY BAKARI OMARY

AQUARIUS

6-Jun-18

1337900

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

 

[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