+ Reply to Thread
Results 1 to 1 of 1

Copy an entire row when ever the value in a column changes

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    US
    MS-Off Ver
    Excel Office 365
    Posts
    66

    Copy an entire row when ever the value in a column changes

    I have this very large table that's 29 columns wide and over 10,000 rows. Is there a way to have a piece of VBA code that does the following:
    Create a second table to the right side of the first table starting at column AO
    The first row of the second table will be a copy of the first rows headers
    The second row of the second table will be a copy of the second row from the first table (first instance of the value in Column D)
    The third row of the second table will be a copy of the first tables next row only if the value in Column D changes.
    The forth row will of the second table will be a copy of the first tables next row only after the value in Column D changes again.
    This would repeat until the last row. I attached what the data looks like and a sample of what the output should resemble.
    The end result is basically a new table containing only the first instance of a row when ever the value in Column D changes.

    Any help would be very appreciated.
    Attached Files Attached Files

+ 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. Copy Entire Row If Column A = Bankys
    By frank35 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-18-2013, 10:41 PM
  2. Copy entire column IF...
    By LoooM in forum Excel General
    Replies: 2
    Last Post: 09-18-2013, 12:37 PM
  3. Copy entire selected column to next columns till last column
    By siroos12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2013, 05:20 AM
  4. Copy entire row EXCEPT column A
    By branedead in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-10-2012, 09:51 AM
  5. Copy entire row to a another sheet if a column value = X
    By jacoolero in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-20-2010, 02:28 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