Results 1 to 7 of 7

Need vba to delete the rows depends upon criteria of 3

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-25-2015
    Location
    bangalore
    MS-Off Ver
    2019
    Posts
    120

    Need vba to delete the rows depends upon criteria of 3

    Dear experts

    I need your valuable time to my task to accomplish

    i have set of data in which b:b column have contains of amount value(plus,minus,zero)
    in that i want delete rows which are rows come under certain criteria depends upon country code refelct debit and credit values so it match same value as 0 then minus values rows should be deleted then zero rows should be deleted. keep rest of values which not under these criteria

    Like EMAE454 country code twice refelcts under which amount reflect debit/credit balance so it should be delete.

    see the attachment
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Delete rows once the two criteria are met
    By lakh4u2001 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2014, 03:49 AM
  2. Ms access Vba Save Data to xl depends upon 1 table pick & Depends 2 Upon fiterDate
    By breadwinner in forum Access Programming / VBA / Macros
    Replies: 14
    Last Post: 05-29-2014, 10:59 PM
  3. [SOLVED] Delete rows with Certain Criteria
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2013, 05:52 PM
  4. [SOLVED] how to delete delete rows with criteria and keeping formula
    By Bremmah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2013, 07:09 AM
  5. [SOLVED] Delete certain rows with criteria
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-29-2012, 06:12 PM
  6. how to delete rows not containing the criteria
    By sasswe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2008, 02:11 AM
  7. vba to delete rows if criteria not met
    By peterkiukas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2007, 03:40 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1