Results 1 to 10 of 83

Thread: Delete rows based on match criteria in two excel files or single Excel File

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #9
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0

    conditionally delete or replace entire row

    vba is placed in a seperate files macro.xlsm
    & there are two more files 2.xlsx and 1.xlsx
    all files are located in a different place
    i uploaded the pic of 1.xlsx & 2.xlsx plz look sir
    if column A of 1.xlsx matches with column B of 2.xlsx then keep that entire row of 2.xlsx & if not matches then delete the entire row of 2.xlsx
    in this example 3rd row will be deleted of 2.xlsx
    i need the macro of the same sir
    so plz have a look into this problem and help me in solving this problem sir
    plz see the sample file
    Attached Images Attached Images
    • File Type: png 1.PNG (4.1 KB, 7 views)
    • File Type: png 2.PNG (10.8 KB, 7 views)

Similar Threads

  1. Replies: 29
    Last Post: 06-09-2020, 06:00 PM
  2. Replies: 3
    Last Post: 10-20-2015, 12:51 PM
  3. VBA To Delete Rows Based On Value Criteria In A Column
    By jffryjsphbyn in forum Excel Help
    Replies: 1
    Last Post: 08-15-2013, 12:45 PM
  4. Replies: 6
    Last Post: 08-14-2013, 04:25 PM
  5. Delete Remove Rows By Criteria VBA Excel
    By marreco in forum Excel Help
    Replies: 5
    Last Post: 12-20-2012, 05:56 PM

Tags for this Thread

Posting Permissions

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