Results 1 to 10 of 30

Thread: Delete rows based on match criteria in two excel files, 1 might be .csv file .Opened in Excel=Fail Chaos

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 05-28-2020, 02:56 PM #25
    DocAElstein
    DocAElstein is online now
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10

    If condition match then delete entire row by vba else do nothing

    Here we go again recycle another cycle


    https://www.excelforum.com/excel-pro...o-nothing.html

    Quote Originally Posted by MollyBread
    Hi Experts,

    I am looking for a macro details are mentioned below & plz see the sample file

    Thnx For the Help

    If column J has BUY then compare column K with column with column H & if column K is Greater than column H then do nothing else delete entire row
    If column J has SELL then compare column K with column with column H & if column K is smaller than column H then do nothing else delete entire row
    If column J has DELETE then delete entire row by vba
    Last edited by DocAElstein; 07-09-2020 at 10:55 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Delete One Row From A 2D Variant Array
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 18
    Last Post: 02-23-2020, 03:10 PM
  2. Delete Filtered Result, Sort From Specific Row And Delete Entire Row Having No Pairs
    By analyst in forum Excel Help
    Replies: 6
    Last Post: 03-26-2014, 03:04 PM
  3. Delete Entire row if cell value does not have either two of specific word
    By analyst in forum Excel Help
    Replies: 1
    Last Post: 02-25-2014, 10:55 PM
  4. Delte a specific column and does not delete the top row
    By jffryjsphbyn in forum Excel Help
    Replies: 1
    Last Post: 06-13-2013, 02:00 PM
  5. Need to Delete Multiple Row based on Conditions
    By jdlee in forum Excel Help
    Replies: 4
    Last Post: 03-22-2013, 01:47 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