+ Reply to Thread
Results 1 to 8 of 8

insert row at truck plate number

Hybrid View

  1. #1
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: insert row at truck plate number

    Something like this?
    Sub dotch()
       Dim lRow As Long
       For lRow = Cells(Cells.Rows.Count, "G").End(xlUp).Row To 2 Step -1
          If Cells(lRow, "G") <> Cells(lRow - 1, "G") Then Rows(lRow).EntireRow.Insert
       Next lRow
    End Sub
    Click the * Add Reputation below to say thanks.

  2. #2
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2013 PRO PLUS
    Posts
    3,695

    Re: insert row at truck plate number

    T124BKT did should have not been separated

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Calculating Truck Waiting Time & Truck Unloading Time
    By Aldy Johan in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-25-2017, 11:23 PM
  2. Duplicate License Plate Formula
    By piper823 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-12-2015, 08:30 AM
  3. matching number plate macros
    By Dcumby in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2013, 08:24 AM
  4. Sorting License Plate Data
    By bhasky in forum Excel General
    Replies: 2
    Last Post: 12-28-2010, 01:41 PM
  5. Enter number plate and add 1
    By badenairpark in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2008, 08:45 AM
  6. Color Plate
    By ali786 in forum Excel General
    Replies: 2
    Last Post: 06-05-2008, 04:31 AM
  7. [SOLVED] Working out the age of a vehicle from UK Registration plate
    By zigs71 in forum Excel General
    Replies: 0
    Last Post: 02-07-2006, 10:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1