+ Reply to Thread
Results 1 to 2 of 2

Hide or Unhide Rows on one sheet based on value entered in cell on another sheet

  1. #1
    Registered User
    Join Date
    12-05-2014
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    12

    Question Hide or Unhide Rows on one sheet based on value entered in cell on another sheet

    Greetings folks,
    I have a work book and on Sheet 1 Cells A1, A2, A3, A4 are blank, but if a user puts in a value in A1, I would like it to unhide Rows 1-5 on sheet 2, and if user clears A1 on sheet 1, I would like rows 1-5 on sheet 2 to be hidden again. If users puts entry in A2 on Sheet 1, I would like it to unhide rows 6-10 on sheet 2 and if they clear the value in A2, I would like it to rehide rows 6-10

    Right now users have to add and remove rows or copy and paste information to notepad to change values. The user can have 4 chioces A1 - A4 and each entry will have some cells that start out hidden on sheet 2. If they add an entry it will unhide them. If they clear entry it will rehide them.

    I hope this makes sense.

    We have a spreadsheet that our engineers use to generate a configuration script they they copy and paste into devices to configure them. Being able to create the whole spreadsheet and have certain rows hidden or unhidden based on values they place on the variables sheet (sheet 1 from example above) would be a great addition to our existing spreadsheet.

    Thanks in advance for any assistance you can provide.

    Wally

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,428

    Re: Hide or Unhide Rows on one sheet based on value entered in cell on another sheet

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Hide/unhide rows based on cell value of another sheet
    By Vivek2705 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2016, 07:55 AM
  3. [SOLVED] Hide and Unhide rows on multiple sheets based on a validation list on a single sheet
    By bbarth in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-30-2015, 02:10 PM
  4. Vb code to hide/unhide rows based on entries on another sheet
    By tcrjmom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2015, 01:15 PM
  5. Replies: 2
    Last Post: 09-22-2014, 12:52 PM
  6. [SOLVED] Hide Unhide clomun based on cell value in another sheet
    By sameeru in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2013, 04:42 AM
  7. [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

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