+ Reply to Thread
Results 1 to 3 of 3

Hide rows based on empty cells in other sheet

  1. #1
    Forum Contributor
    Join Date
    04-20-2017
    Location
    SWEDEN
    MS-Off Ver
    2016
    Posts
    123

    Hide rows based on empty cells in other sheet

    It's kind of a messy thing, but it's the same maneuver throughout the whole sheet

    In sheet1 I have 2 parametres multiple times:

    Sheet1 if C4 is blank, in sheet2 hide rows 2:4
    Sheet1 if C5 is blank, in sheet2 hide row 4
    Sheet1 if C6 is blank, in sheet2 hide rows 5:7
    Sheet1 if C7 is blank, in sheet2 hide row 7
    Sheet1 if C8 is blank, in sheet2 hide rows 8:10
    Sheet1 if C9 is blank, in sheet2 hide row 10

    This goes on down to sheet1 C37.
    The first cell will never be blank if there is something in the second, ie. C4 be blank and C5 not

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,947

    Re: Hide rows based on empty cells in other sheet

    Please Login or Register  to view this content.
    Last edited by Bernie Deitrick; 09-24-2018 at 09:42 AM.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Hide rows based on empty cells in other sheet

    Give this a try:

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for rep!

+ 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. VBA to hide empty rows in different sheet
    By HereComesTheBoom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2018, 06:48 AM
  2. Hide empty rows based on information entered on first worksheet
    By ElaineMok in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2016, 12:24 PM
  3. Hide worksheets and rows based on empty cells
    By bgasypher in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2014, 03:23 PM
  4. Hide Rows on one Sheet based on cells in another sheet being empty
    By KDF in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2013, 01:48 PM
  5. Excel 2007 : How to Hide rows if data cells are empty?
    By gene070752 in forum Excel General
    Replies: 0
    Last Post: 12-04-2011, 05:00 PM
  6. Replies: 0
    Last Post: 09-07-2011, 07:51 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