Results 1 to 6 of 6

VBA code to delete duplicate rows based on multiple conditions

Threaded View

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2011
    Posts
    6

    VBA code to delete duplicate rows based on multiple conditions

    Hello,

    I would like to create a VBA code that will delete rows if they are the same as a previous row. However, not all of the data may be the same throughout all of the rows so I need to be specific about the columns that will be used to see if the rows are the same. The columns that I would like to see if there is a match is the code, date, data 1, and data 2. If all of these criteria are the same for any of the other rows on the sheet, I would like them deleted. I have attached a small sample. In the sample the code should result in either row 2 or row 3 being deleted. Thank you for your help.
    Attached Files Attached Files
    Last edited by pjsween; 06-27-2012 at 10:17 AM.

Thread Information

Users Browsing this Thread

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

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