Hi,
I need to hide column f or column g based on text in cell b2, I would like the 2 column to auto switch if possible please.
If "B2" contains "Darrell" so hide column "G" and un hide column "F".
If "B2" contains "Brendon" hide column "F" and un hide column "G".
If "B2" is empty un hide "F" & "G"
Any help is always much appreciated.
This is so easy I'm wondering why you're asking. You can turn on the macro recorder and hide / unhide columns F & G.,...and then put an If range("B2").value =......statement to do the rest.
If you're not sure about how to use the macro recorder or what an If statement is then I suggest starting here: http://www.excelforum.com/excel-prog...materials.html
Last edited by BellyGas; 08-03-2015 at 09:06 AM.
I think this should do it.
Here is the code itself:
Please Login or Register to view this content.
Many thanks bmouse, brilliant!
It's only that easy when you know how! Thanks for the link.
Here's a similar version that will do the task automatically when cell B2 is changed.
By using SELECT / CASE structure instead of IF / ELSEIF, you can easily add more values if needed.
Place this in the code section for the sheet you are working with.
Please Login or Register to view this content.
If this has been helpful, please click on the star at the left.
Thank you very much StuCram this is exactly what I wonted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks