+ Reply to Thread
Results 1 to 2 of 2

Checking values between cells and then applying filters/hide rows

  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    11

    Checking values between cells and then applying filters/hide rows

    So I want to check the values (non-numerical) between two or three cells, in the same row but different columns, and if they are the same then apply a filter that would hide that entire row. How can you make a macros do that?

    But the columns to be checked are part of a range that I have a macros that hide certain columns depending on what I want to see, so can the macros just check the cells in column that are not hidden within the desired range?

    The table is A12:AK2000 and the columns range that I'd like checked is L:AK only


    So, to further explain:

    if I have only column L and N visible, I'd like to check every single cell (in those columns) and see if the same row cells in these columns match, and if they do, filter those values out (or hide that row) but if they don't match don't do anything to the row (especially if there is not matches rows down).
    Additionally, if I were to have four columns visible, all cells in the same row must match to filter/hide that row otherwise do nothing.

    Thanks!
    Feel free to ask question, if I wasn't clear. I know it's a messy request

  2. #2
    Registered User
    Join Date
    10-25-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Checking values between cells and then applying filters/hide rows

    Alternatively, I have conditional formating on those columns. Could a macros check if the same row cells have the same rule applied and filter/hide the values/row?

+ Reply to Thread

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