+ Reply to Thread
Results 1 to 3 of 3

Macro - Identify Record sets and delete related Records

  1. #1
    Registered User
    Join Date
    07-28-2012
    Location
    Morgantown, WV
    MS-Off Ver
    Excel 2007
    Posts
    54

    Macro - Identify Record sets and delete related Records

    Excel Forum Masters.

    I am requesting assistance on how to identify group of records using unique IDS, then deleting related records based on numbers from another field, Please view the Excel Forum 1 File.

    I have created instructions that are very clear and precise using images and Text.

    I appreciate your time and effort in helping me on this Macro.

    Regards,

    Haleakala17

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro - Identify Record sets and delete related Records

    My output data are different as mine uses the original sheet while your output is based on different sheet. For e.g you have duplicates for nos 6 and 8 in sheet origial
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-28-2012
    Location
    Morgantown, WV
    MS-Off Ver
    Excel 2007
    Posts
    54

    Re: Macro - Identify Record sets and delete related Records

    AB33

    Thank you very much, it works great!

+ 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. Delete Duplicate records but keep 1 record with most recent date
    By bcn1988 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-07-2015, 02:28 AM
  2. [SOLVED] How can I identify if a record has two different records?
    By jgomez in forum Access Tables & Databases
    Replies: 5
    Last Post: 01-27-2014, 02:43 PM
  3. Help creating a macro to identify and delete specific rows.
    By Dez23 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2012, 04:54 PM
  4. delete duplicate records after totaling a field from each record
    By HarrySpencer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2007, 09:49 AM
  5. How to delete duplicated records. Each record has four lines
    By Arcesio Hernandez in forum Excel General
    Replies: 2
    Last Post: 07-26-2005, 07:05 PM

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