i need help
i need help
Last edited by iamgujju; 06-26-2019 at 08:11 AM.
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.
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
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.
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!
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
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.
Last edited by AliGW; 06-26-2019 at 12:05 PM. Reason: Please don't quote unnecessarily!
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!
As advised in post #5, provide a sample workbook.
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!
anyone please - if you can help me with VBA code that would be much appreciated.
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.
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.
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.
Cross posted...https://www.mrexcel.com/forum/excel-...light=iamgujju
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks