Results 1 to 3 of 3

Delete row if total is equal to 0.00%

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    Philadelphia
    MS-Off Ver
    Excel 2007
    Posts
    32

    Delete row if total is equal to 0.00%

    Hello,

    I am attempting to build a macro that looks at a certain cell. If that cell is equal to 0.00%, then it will delete the entire row. I would need it to repeat the same function until it finds no more data in the selected cell. In addition, I have multiple tabs within the excel spreadsheet that are set up the same exact way. Is there a way for the macro to repeat the same task on any tab within the file?

    I am attaching a spreadsheet as a reference.

    Basic Summary:

    Column BI is where the macro would need to look for specific percentages. If the percentage equals 0.00%, then delete. If it is any higher than that, then keep the row and continue down the list. Repeat same function on tab 2 or any additional tabs.

    I am asking this question from a beginner standpoint, so I appreciate any type of advice.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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