Results 1 to 16 of 16

Delete rows based on cell number value lower than certain Value

Threaded View

  1. #1
    Registered User
    Join Date
    05-27-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    20

    Lightbulb Delete rows based on cell number value lower than certain Value

    Hi Good day guys

    I am truly stuck with this one Macro I'm trying to create and wonder if anyone could please assist me, would be much appreciated.

    I am trying to delete entire rows based on the values in two columns Q & R, I want only the rows remaining that has a cell value 'above' 5. I want this macro to look at column Q & R and if the cells in those columns are below either -5 or +5 then I want the macro to delete those rows.

    For example if column Q or R have a cell value of -6;-7;-10 or 6;7;8;10;5 then the rows that those cells are located in will -not- be deleted, but if the values are 4;-4;3;-3;2 or -2 (I am talking about absolute value) the rows containing those cells will be removed and deleted with the cells automatic shifting up so that there are no blank rows between the data I have.

    To add condition to this macro making it a bit more complicated, I have another column (O) that has a series of numbers in them that have repetitive duplicate values. The cells that exceed the set value of a absolute 5 , the O column in that row has a number of lets say 120 then all duplicate numbers of 120 in Column O should not be deleted even if the rows do not meet the first condition of exceeding an absolute value of 5.

    I am attaching a workbook of mine with added notes and examples of which rows would be deleted with this post, please if you have a moment have a look into it for more clarity.

    Useful extra info:
    The data I work with will almost never have the same amount of rows, always have the same amount of columns and might not always be in the same named worksheet. The blank Column U is already in use by another macro I have.

    Any type of assistance or tips anyone can give me would be helpful, I am open to receive any type of help no matter how small of a help.
    Just want to say thanks in advance for having a look at my difficulty I'm having, thanks for your dedicated time. And please don't shy away from asking questions if you feel like helping but do not have enough clarity on what I'm looking for, I'll respond as quick as I can .

    Cheers guys.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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