+ Reply to Thread
Results 1 to 2 of 2

Hide row based on a cell value of a different sheet

  1. #1
    Registered User
    Join Date
    02-20-2019
    Location
    Orlando
    MS-Off Ver
    2010
    Posts
    16

    Hide row based on a cell value of a different sheet

    Hello!

    Is it possible to hide an entire row based on the value of a cell in a different sheet?

    For example, if in sheet1 I have someone's name in a cell (b12), and in sheet2 I have a cell saying yes or no, if the answer is yes, how can it hide the entire row automatically in Sheet 1?

    Thanks, everyone!

  2. #2
    Registered User
    Join Date
    02-20-2019
    Location
    Orlando
    MS-Off Ver
    2010
    Posts
    16

    Re: Hide row based on a cell value of a different sheet

    I've attached the Worksheet.

    So If John Smith was terminated, in the summary section, can he be automatically hidden?
    Attached Files Attached Files

+ 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. Hide/Unhide Sheet based on cell value
    By mmogharreban in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-17-2022, 06:28 PM
  2. Auto-hide cells in one sheet based on the value in a cell in another sheet
    By rachrxg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2018, 02:23 PM
  3. Hide or Unhide Rows on one sheet based on value entered in cell on another sheet
    By wfsteadman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2016, 07:30 PM
  4. Hide Sheet Based on Cell Value
    By duncanfootitt in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-11-2013, 07:48 AM
  5. [SOLVED] Hide / Unhide Row on a Sheet based on the Value of a Cell on Another Sheet
    By neslotna in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2013, 12:23 PM
  6. Macro to hide sheet based on cell value within the sheet
    By a_dub_green in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-04-2012, 12:18 PM
  7. Hide sheet based on yes/no cell
    By Ace Rimmer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2010, 06:53 AM

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