How to hide columns whose cell do not match a specific value
Dear All
Is there a way to hide a column if there isn't a specific value?
Let's say I have the following data on my spreadsheet
A1 = H012
B1 = 20 Jun
B2 = H012
B3 = H011
C1 = 21 Jun
C2 = H011
C3 = H011
D1 = 22 Jun
D2 = H012
D3 = D011
I would like to hide all the columns that do not have the value I specify in cell A1.
I would need this to work throughout the whole spreadsheet if possible as I will be adding numerous columns).
Thank you so much for your help!
Marco
Maybe:
Please Login or Register to view this content.
Another approach:Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
This will need to be a macro
How do you intend to trigger the macro?
The Macro itself will be quite simple to write.
Mumps's solution is similar to what I would do.
But Mumps forgot to invert the selection.
Ok this is your code, right click on the sheet name at the bottom of excel and select view code to edit it.:-
Please Login or Register to view this content.
Last edited by mehmetcik; 06-30-2015 at 01:11 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thank you so much guys. I would like to trigger the macro every time there is a value that is different than "" in A1.
In an ideal world I would also like to hide all the rows where the value in A1 is not present.
And also, I would like to unhide all the columns and rows if A1 is "".
I am really sorry if I sound daft, I am completely new to this!
Thank you!
You start out wanting to hide Columns, and end up saying Rows?
Thank you John. Yes I then realised I needed to hide both, but I got to the bottom of it thanks to a forum user!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks