+ Reply to Thread
Results 1 to 3 of 3

delete data for sheet based on two columns contain same values

  1. #1
    Forum Contributor
    Join Date
    11-14-2021
    Location
    africa
    MS-Off Ver
    2016 & 2019
    Posts
    255

    delete data for sheet based on two columns contain same values

    Hi

    I want matching data bewteen two sheets based on column D,E contains the same data , the second sheet should delete data based on first sheet

    if the same values for column D,E are existed in second sheet with matching first sheet should keeping otherwise should delete the others

    as you note in first sheet there is duplicate items also second sheet , if the second sheet contains duplicates items and the same values but the duplicates are more than firs sheet then should delete it and just keep duplicates based on first sheet , and if there is new in second sheet but not existed in first sheet also should delete and if if there is new items in first sheet but not existed in second sheet should be add to second sheet all of this depend on column D,E except one case if there is the same values in column D,E but different item then should delete it .
    so in other meaning result implement for sheet2 based on matching with sheet1 with theses conditions:

    1- different values in column D,E with the same item in column B should delete it.
    2- same item in column B& values shouldn't delete it ,but doesn't duplicates more than first sheet.
    3- same values for column D,E but different item in column B should delete it
    4- different values and item should delete it
    5- different item and different values in first sheet and not existed in second sheet should add second sheet .
    6- same item & values in first sheet and not existed in second sheet should add to second sheet
    7- differen item & values for column D,E should delete from second sheet
    8- the result should be in second sheet like three sheet
    9- data colud be 7000 rows
    finally I posted also here
    https://www.mrexcel.com/board/thread.../#post-5955653
    thanks
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-14-2021
    Location
    africa
    MS-Off Ver
    2016 & 2019
    Posts
    255

    Re: delete data for sheet based on two columns contain same values

    I hope some body help

  3. #3
    Forum Contributor
    Join Date
    11-14-2021
    Location
    africa
    MS-Off Ver
    2016 & 2019
    Posts
    255

    Re: delete data for sheet based on two columns contain same values

    can any body see my request,please?

+ 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. how to delete rows based on the certain values in several columns
    By nazaninibb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2018, 07:00 AM
  2. [SOLVED] Delete range based columns in sheet 1
    By cpramesh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-05-2017, 06:55 AM
  3. Cut Row to New Sheet, Delete From Previous - based on value in two different columns
    By gennalaura in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2017, 12:40 AM
  4. [SOLVED] Delete Sheet Rows & Columns based on cell value
    By brendangroff in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-10-2016, 05:22 PM
  5. Delete Columns( From One Sheet) based on the header name from a list.
    By v_a_royston in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-29-2015, 08:07 PM
  6. Replies: 2
    Last Post: 04-02-2015, 12:27 PM
  7. Macro to Delete Columns based on values in specific cells
    By Floydlevedale in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2013, 08:51 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