Results 1 to 5 of 5

Hide/Unhide rows and column based on cell value

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-08-2013
    Location
    Goergia USA
    MS-Off Ver
    Excel 2007
    Posts
    102

    Hide/Unhide rows and column based on cell value

    HI, I need your assistance with the following:

    When this Excel form is being filled out, columns H through M will be hidden and rows 9 through 21 will be hidden

    Here's what I need help with: (note: cells G5 and I5 are drop downs with Yes and No answers)

    If the user selects YES (cell G5), I need only rows G9:G21 to unhide
    If the user selects NO (cell G5), I need columns H and I to unhide, BUT rows I9:I21 to stay hidden

    THEN
    If the user selects YES (cell I5), I need rows I9:I21 to unhide
    If the user selects NO (cell I5), I need columns J through M to unhide

    Please Note: if I picked YES in cell G5 or I5 (by mistake), and then chose NO, I need Excel to toggle/revert back and hide rows G9:G21 (or I9:I21) once NO is picked

    Please see attached sample file.

    Any help is greatly appreciated! THANKS SO MUCH IN ADVANCE!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to unhide & hide rows based on column value
    By qvfr034 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-15-2020, 03:00 PM
  2. Hide/Unhide rows and column based on cell value
    By marshak in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-10-2020, 08:41 PM
  3. [SOLVED] Need Help with Hide/Unhide Rows Based on Zero Value in Column
    By amyly2n in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-31-2019, 03:43 PM
  4. Automatically hide/unhide rows based on column A value
    By c.bernardo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2017, 12:30 AM
  5. Hide/Unhide Rows based on column data using checkbox
    By ricklberry in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2015, 11:39 AM
  6. [SOLVED] VBA macro that hide and unhide column to respective rows based on first column value
    By janine6192 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-14-2013, 06:21 PM
  7. Macro to Hide/Unhide Rows Based on Results in Column Equation
    By jwhite0720 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2011, 04:59 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