+ Reply to Thread
Results 1 to 6 of 6

Delete unwanted rows and update count of rows based on values

  1. #1
    Registered User
    Join Date
    08-28-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    92

    Question Delete unwanted rows and update count of rows based on values

    Can you please help me with code to delete the data which is not required and update the total count based on certain values.

    Requirements :
    I want entire rows to be deleted if the value in column B is "not suppresed" or if the value in column F is "CAXW"
    and also i want to have the total count of rows in sheets ("Totals") for each value in column K based on regions in column L.

    Please refer the raw data sheet (28_March) and desired sheet. thank you very much for your help in advance.

    any help would be much appreciatedDesired sheet.xlsx28_march.xlsx
    Last edited by boddulus; 03-31-2015 at 08:38 PM.

  2. #2
    Forum Contributor Anka's Avatar
    Join Date
    08-25-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2016
    Posts
    174

    Re: Delete unwanted rows and update count of rows based on values

    To delete unwanted rows you can find here a good starting point.
    Delete row if a specific value exist (VBA). Ron de Bruin
    Many thanks to all who have helped me.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Delete unwanted rows and update count of rows based on values

    Maybe:

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-28-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    92

    Re: Delete unwanted rows and update count of rows based on values

    Thanks for the help Davis.

    This was perfect and it worked exactly but in this way i have define lot of variables can it be more simplified .because i want total of all exceptions in every region in the sheet ,i just showed you some examples in desired sheet.but the actual sheet is very huge.
    Please refer the original sheet and let me know if that is possible.

    Anyway thanks for the help.

  5. #5
    Registered User
    Join Date
    08-28-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    92

    Re: Delete unwanted rows and update count of rows based on values

    Can someone help me on this please ? please refer to my original post . thanks in advance.

  6. #6
    Registered User
    Join Date
    08-28-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    92

    Re: Delete unwanted rows and update count of rows based on values

    Is there any one who can help me on this ?

    Thanks in advance

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Delete Unwanted Rows
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-08-2013, 11:07 AM
  2. how to delete unwanted rows?
    By sumesh56 in forum Excel General
    Replies: 3
    Last Post: 04-20-2013, 08:48 PM
  3. How to delete the last unwanted rows
    By zaska in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-17-2013, 09:11 AM
  4. Delete Unwanted Rows
    By adam2308 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2012, 08:33 AM
  5. Replies: 0
    Last Post: 02-21-2010, 06:09 AM

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