+ Reply to Thread
Results 1 to 6 of 6

Drop Down List value to Hide Rows

Hybrid View

rabbit8 Drop Down List value to Hide... 07-13-2010, 11:22 AM
Marcol Re: Drop Down List value to... 07-13-2010, 12:02 PM
rabbit8 Re: Drop Down List value to... 07-13-2010, 01:33 PM
ek2112 Re: Drop Down List value to... 01-11-2012, 03:22 PM
koteshi Re: Drop Down List value to... 04-14-2014, 05:49 AM
arlu1201 Re: Drop Down List value to... 04-15-2014, 01:00 AM
  1. #1
    Registered User
    Join Date
    08-25-2011
    Location
    Taipei, Taiwan
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Drop Down List value to Hide Rows

    I hope nobody minds I am reviving a dead thread but I am facing currently a similar problem:

    I have an Excel 2007 sheet with a drop down list which looks like this.

    \1
    2014-04-14_172511.png

    My plan is now that whenever someone picks the values CP320, CP320s or CP320n from the drop down list (marked yellow), the rows 12-14 (marked blue) will be automatically hidden. If the values CP321, CP321s or CP321n are selected the rows reappear.

    I am pretty sure this can be done with a nice VB macro, however unfortunately I lack the skills to do it by myself. I've tried other approaches, like the one mentioned in this thread, but they all failed.

    Anyone willing to help me on this one?
    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)

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