+ Reply to Thread
Results 1 to 2 of 2

Hiding Rows depending on a value

  1. #1
    Forum Contributor
    Join Date
    08-10-2017
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    141

    Hiding Rows depending on a value

    Hi Guys,

    Not sure if this is possible.

    Can excel auto hide rows when a certain name is populated in a cell?

    I have created a template.

    Essentially

    When i input values from my work into row 14 Column K will tell me if i need a bottom shelf or top shelf

    Is it possible once that is populated for excel to auto hide 19-21 if Column K states use bottom shelf?

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Hiding Rows depending on a value

    Try (into Sheet1 code):

    Please Login or Register  to view this content.
    check attached file.
    Attached Files Attached Files
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ 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. [SOLVED] Hiding Rows Depending on Their Value
    By EdWoods in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-31-2018, 04:09 PM
  2. [SOLVED] Hiding sheets/rows depending on the value in a cell.
    By ctownballer03 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2016, 09:20 PM
  3. Macros auto hiding of rows depending on cell content
    By nad23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2012, 12:40 PM
  4. [SOLVED] Hiding rows depending on the value of a cell picked from a drop down menu
    By orly_sm in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-11-2012, 03:30 PM
  5. Replies: 0
    Last Post: 11-10-2012, 11:05 AM
  6. Hiding rows depending on data
    By oakman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-03-2006, 12:21 PM
  7. Replies: 2
    Last Post: 10-18-2005, 10:05 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