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. 07-17-2020, 12:51 PM #17
    fixer
    fixer is offline
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0
    I would like to notify something about this macro and about this post
    in this macro
    Code:
    Let Lr2 = Ws2.Range("A" & Ws2.Rows.Count & "").End(xlUp).Row   ' it will be ws1, not ws2 bcoz by using ws1 i am getting correct output



    plz have a look to the sample file & macro too...
    Problem is Solved according to me But any more suugesstion is welcome
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Delete rows based on match criteria in two excel files, 1 might be .csv file .Opened in Excel=Fail Chaos
    By fixer in forum Test Area
    Replies: 29
    Last Post: 06-09-2020, 06:00 PM
  2. Unique Concatenate Range, multiple rows, Index Match Mutliple Criteria
    By youngja in forum Excel Help
    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. Sort Data By Multiple Columns And Delete Some Rows Based On Criteria
    By valesilver in forum Excel Help
    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

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
  •  

Forum Rules