+ Reply to Thread
Results 1 to 15 of 15

help please - hide unhide rows and columns based on drop down selection

Hybrid View

iamgujju help please - hide unhide... 06-26-2019, 08:03 AM
AliGW Re: help please 06-26-2019, 08:06 AM
iamgujju Re: help please 06-26-2019, 08:08 AM
AliGW Re: help please - hide unhide... 06-26-2019, 08:15 AM
iamgujju Re: help please - hide unhide... 06-26-2019, 08:19 AM
Glenn Kennedy Re: help please - hide unhide... 06-26-2019, 08:19 AM
iamgujju Re: help please - hide unhide... 06-26-2019, 08:28 AM
iamgujju Re: help please - hide unhide... 06-26-2019, 08:31 AM
AliGW Re: help please - hide unhide... 06-26-2019, 08:21 AM
iamgujju Re: help please - hide unhide... 06-26-2019, 08:29 AM
iamgujju Re: help please - hide unhide... 06-26-2019, 10:59 AM
AliGW Re: help please - hide unhide... 06-26-2019, 12:08 PM
iamgujju Re: help please - hide unhide... 06-28-2019, 11:54 AM
dangelor Re: help please - hide unhide... 06-28-2019, 01:39 PM
dangelor Re: help please - hide unhide... 07-01-2019, 10:56 AM
  1. #1
    Registered User
    Join Date
    01-05-2014
    Location
    northampton
    MS-Off Ver
    Excel 2010
    Posts
    8

    help please - hide unhide rows and columns based on drop down selection

    i need help
    Last edited by iamgujju; 06-26-2019 at 08:11 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2509 (Windows 11 Home 24H2 64-bit)
    Posts
    92,380

    Re: help please

    Administrative Note:

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    01-05-2014
    Location
    northampton
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: help please

    Hi,

    i need whatever selected from drop down at particular cell - stay unhide from range and the rest others needs to be hidden.

    say for example if i select "Monday" from drop down - those rows and columns contain "Monday" stay unhide and show on the screen - the rest rows and columns like "Tue, Wed, Thu" etc hide .

    please advise - thanks

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2509 (Windows 11 Home 24H2 64-bit)
    Posts
    92,380

    Re: help please - hide unhide rows and columns based on drop down selection

    Thank you. Next time you start a thread here, please take time to compose a good title and put all your requirements into the opening post.

  5. #5
    Registered User
    Join Date
    01-05-2014
    Location
    northampton
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: help please - hide unhide rows and columns based on drop down selection

    Sure AliGW,

    please accept an apology.....as i have mentioned i am seeking for help for Hide / Unhide Rows and Columns based on drop-down ..... i have tried one code its working but its hiding what suppose to show on the screen - say for example if i select day 1 - data for the day 1 should apprear on screen from range c6 to ca1000 but unfortunately its hiding those data which contains day 1 and showing all other data i.e. day 2, day 3 etc... would it possible for you to help me please.
    Last edited by AliGW; 06-26-2019 at 08:20 AM. Reason: Please don't quote unnecessarily!

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: help please - hide unhide rows and columns based on drop down selection

    I don't understand your explanation at all!!

    Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever). Please don't attach a picture of an Excel sheet (no-one will want to re-type all your stuff before starting).

    1. It does NOT have to be your real sheet - mock up a SAMPLE if you need to. But not 1000's of rows!!! It makes manual checking so tedious. Whatever you do... make sure that all confidential information is removed first!!

    2. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    3. Make sure that your desired solution is also shown (mock up the results manually).

    4. Try to avoid using merged cells. They cause lots of problems!

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  7. #7
    Registered User
    Join Date
    01-05-2014
    Location
    northampton
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: help please - hide unhide rows and columns based on drop down selection

    Hi Glenn,

    please find attached - i have highlighted Monday in different background colour - so if i select Monday from drop-down those rows and columns - stay on the screen and the rest needs to be hidden.

    thank you in advance.
    Attached Files Attached Files
    Last edited by AliGW; 06-26-2019 at 12:05 PM. Reason: Please don't quote unnecessarily!

  8. #8
    Registered User
    Join Date
    01-05-2014
    Location
    northampton
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: help please - hide unhide rows and columns based on drop down selection

    Hi,

    i am going to use for 79 columns and 1000 rows....
    Last edited by AliGW; 06-26-2019 at 12:06 PM. Reason: Please don't quote unnecessarily!

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2509 (Windows 11 Home 24H2 64-bit)
    Posts
    92,380

    Re: help please - hide unhide rows and columns based on drop down selection

    As advised in post #5, provide a sample workbook.

  10. #10
    Registered User
    Join Date
    01-05-2014
    Location
    northampton
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: help please - hide unhide rows and columns based on drop down selection

    Hi AliGW,

    i have posted sample sheet now - thank you.
    Last edited by AliGW; 06-26-2019 at 12:06 PM. Reason: Please don't quote unnecessarily!

  11. #11
    Registered User
    Join Date
    01-05-2014
    Location
    northampton
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: help please - hide unhide rows and columns based on drop down selection

    anyone please - if you can help me with VBA code that would be much appreciated.

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2509 (Windows 11 Home 24H2 64-bit)
    Posts
    92,380

    Re: help please - hide unhide rows and columns based on drop down selection

    Administrative Note:

    We don't expect you to bump threads more than once in 24 hours - it has been only a couple of hours since you last posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

    Administrative Note:

    Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

    For normal conversational replies, try using the QUICK REPLY box below.

  13. #13
    Registered User
    Join Date
    01-05-2014
    Location
    northampton
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: help please - hide unhide rows and columns based on drop down selection

    afternoon all,

    my query has been sorted now; if you would like i can submit code here - please let me know.

    thanks for looking at my query and trying to help me out; really appreciate it.

  14. #14
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    MS365 V.2406
    Posts
    2,318

    Re: help please - hide unhide rows and columns based on drop down selection

    Possibly, with this code in the worksheet's code module....
    Private Sub Worksheet_Change(ByVal Target As Range)
        Dim c As Range
        If Target = Cells(3, 2) Then
            With ActiveSheet.UsedRange.Offset(3)
                .Rows.EntireRow.Hidden = False
                .Columns.EntireColumn.Hidden = False
                If Target.Value = "All" Then Exit Sub
                Set c = .Find(Target.Value, LookIn:=xlValues)
                Do
                    c.EntireRow.Hidden = True
                    c.EntireColumn.Hidden = True
                    Set c = .FindNext(c)
                Loop While Not c Is Nothing
            End With
        End If
    End Sub
    Last edited by dangelor; 07-06-2019 at 04:25 PM.

  15. #15
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    MS365 V.2406
    Posts
    2,318

    Re: help please - hide unhide rows and columns based on drop down selection


+ 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