insert row at truck plate number

**makinmomb** · 10-09-2018, 05:07 AM

The plate number is at column H

Need macro to insert row from one plate number to another ,
it will help see what truck did how many trips and flow of spares used

I can do this by pivot by i need this by macro to only do me the insert row

If it does correctly i am expecting it will do as follows to the first 6 rows

JOB NO MON TRUCK TRAIL DRIVER TRANS DATE SPARE NO
x 5 T106BCC T254AXM x x 4-May-18 2264100 221

x 4 T106BHX T658BCZ x x 19-Apr-18 321000 108
x 5 T106BHX T658BCZ x x 29-May-18 1332000 357

x 4 T108BVH T221AWK x x 25-Apr-18 1017500 150

x 4 T124BKT 440AUB x x 10-Apr-18 1248000 46
x 5 T124BKT T440AUB x x 22-May-18 2975500 307

**makinmomb** · 10-09-2018, 05:26 AM

This is the file

**dotchiejack** · 10-09-2018, 06:11 AM

Something like this?

Please Login or Register  to view this content.

**makinmomb** · 10-09-2018, 07:43 AM

It does not do as required look at this

JOB NO CLIENT CONTAINER W C DESTINATION MON TRUCK TRAIL DRIVER TRANS DATE SPARE NO

x x x x x x 5 T106BCC T254AXM x x 4-May-18 2264100 221

x x x x x x 4 T106BHX T658BCZ x x 19-Apr-18 321000 108

x x x x x x 5 T106BHX T658BCZ x x 29-May-18 1332000 357

x x x x x x 4 T108BVH T221AWK x x 25-Apr-18 1017500 150
x x x x x x 4 T124BKT 440AUB x x 10-Apr-18 1248000 46

x x x x x x 5 T124BKT T440AUB x x 22-May-18 2975500 307
x x x x x x 5 T126DCZ T602AYW x x 4-May-18 502000 207

x x x x x x 4 T128DCZ T888DCY x x 28-Apr-18 208000 171

**makinmomb** · 10-09-2018, 07:44 AM

T124BKT did should have not been separated

**dotchiejack** · 10-09-2018, 07:54 AM

Please Login or Register  to view this content.

**makinmomb** · 10-09-2018, 07:57 AM

Yes thank you so much , this is working

**dotchiejack** · 10-09-2018, 08:29 AM

Welcome
Have a nice day.

insert row at truck plate number

LinkBack

Thread Tools

Rate This Thread

Display

insert row at truck plate number

Re: insert row at truck plate number

Re: insert row at truck plate number

Re: insert row at truck plate number

Re: insert row at truck plate number

Re: insert row at truck plate number

Re: insert row at truck plate number

Re: insert row at truck plate number

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Calculating Truck Waiting Time & Truck Unloading Time

Duplicate License Plate Formula

matching number plate macros

Sorting License Plate Data

Enter number plate and add 1

Color Plate

[SOLVED] Working out the age of a vehicle from UK Registration plate

Bookmarks

Bookmarks

Posting Permissions