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. #11
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0

    replace the entire row

    there are two files file name sample1.xlsx & sample2.xlsx
    vba will be placed in a seperate file macro.xlsm
    sample1.xlsx is located at C:\Users\WolfieeeStyle\Desktop
    sample2.xlsx is located at C:\Users\WolfieeeStyle\Desktop\Upstox
    macro.xlsm is located at C:\Users\WolfieeeStyle\Desktop
    only macro.xlsm file is opened so we have to open rest 2 file by vba
    If column H of sample2.xlsx matches with Column D then look column B data of sample2.xlsx and find that data in sample1.xlsx in column B and after getting that data in sample1.xlsx in column B , copy that entire row of sample1.xlsx and paste that in sample2.xlsx in the same row
    all this is have to do by vba
    so plz have a look into this problem and help me in solving this problem sir
    sheet name can be anything
    Attached Images Attached Images

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
  •