+ Reply to Thread
Results 1 to 3 of 3

NEED IMMEDIATE HELP - Auto-Hide Rows Based on Data in two columns

  1. #1
    Registered User
    Join Date
    12-05-2013
    Location
    MA, US
    MS-Off Ver
    Excel 2010
    Posts
    3

    NEED IMMEDIATE HELP - Auto-Hide Rows Based on Data in two columns

    Hello All!

    This might be difficult to explain, but please bear with me.

    This document I'm working on contains 250,000 rows. This can't be changed. The document needs to automatically hide or unhide entire rows based on duplicate matches in columns B and J. So as you see in the example below, B2 and J2 are unique, compared to B3 and J3, B4 and J4 and so on. So row 2 would stay unhidden. Row 3 however, (B3 and J3) matches other cells in the B and J columns, so each row that contains subsequent matches in the B and J columns would hide, but the first row that contains these duplicates (in this case B3 and J3) stays unhidden. So in the example below, Row 2,3,8,11 and 12 (highlighted in blue) would be unhidden, either because they're unique or they're the first in a bunch of duplicates. Rows 4,5,6,7,9 and 10 would hide because their cells in columns B and J contain matches. The data on this worksheet is pulled from another ducument elsewhere, so if data in that document changes and something that was a duplicate is now unique, the entire row that contains this updated data in B and J would unhide itself automatically. I know there is a way to write a VBA for this, but I can't figure out how. I'm a newbie to VBA, so if you can figure out how to do this, it be very appreciated.

    --------B---J
    Row 2 100 AT
    Row 3 100 AA

    Row 4 100 AA
    Row 5 100 AA
    Row 6 100 AA
    Row 7 100 AA
    Row 8 100 AB
    Row 9 100 AB
    Row 10 100 AB
    Row 11 101 BZ
    Row 12 101 BG
    Last edited by DLavoie; 12-05-2013 at 12:43 PM.

  2. #2
    Registered User
    Join Date
    12-05-2013
    Location
    MA, US
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: NEED IMMEDIATE HELP - Auto-Hide Rows Based on Data in two columns

    Also, when I wrote "B3:J3" I meant B3 AND J3, not the range of B3-J3. No other columns in between or after columns B and J matters for this formula.

  3. #3
    Registered User
    Join Date
    12-05-2013
    Location
    MA, US
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: NEED IMMEDIATE HELP - Auto-Hide Rows Based on Data in two columns

    Anyone have ideas how this would be done?

+ 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. Auto-hide columns / rows when Cell Values = 0
    By Todd192 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-30-2013, 11:36 AM
  2. want to auto-hide rows based on a value in that row
    By jimboryan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2013, 12:24 PM
  3. Macro to hide both rows and columns simultaneously based on data in cells.
    By walker_dp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2012, 10:47 AM
  4. Macro for auto format hide columns rows??
    By txjackknife in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-02-2009, 01:39 PM
  5. [SOLVED] Auto Hide Columns & Rows
    By appeng in forum Excel General
    Replies: 2
    Last Post: 03-25-2005, 01:06 PM

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