Make columns visible/invisible as per the conditions

[deeps1403]

Hello All,

I have a requirement. I am trying to create a daily task activity sheet. I would like to know, how to make the columns visible and invisible as per the selection from previous column.

For eg:

Column A has a list which has values 'TC creation' , 'TC modification', 'System Test' etc.

Upon selecting TC creation, i need to make a column visible ie 'total tcs created'.

Upon selecting 'TC modification' i would have to make the previous column invisible and make a new column visible for entering no of tcs modified.

Upon selecting 'System test' the other columns should go invisible and make other 3 columns visible for no of tcs executed, no of tcs passed, no of tcs failed etc...

Please help me in getting the solution.Awaiting for the earliest reply.

Thanks in advance,
Deeps

[DonkeyOte]

Can you please post a sample workbook so we can see the columns / ranges in question... remove names etc - all that's required is a cell in which the validation list is present and to understand which columns are to be hidden/unhidden in relation to each choice.

[deeps1403]

I have uploaded a sample spreadsheet.

When I select 'Test case Creation, I should be able to see only column 'E' and 'Q'.
When I select 'Test case Modification,I should be able to see only column 'F' and 'Q'.
When I select 'Test Scenario creation,I should be able to see only column 'G' ,'H' and 'Q'.

etc..


Please help me.

[DonkeyOte]

I presume you're aware that if you hide columns it is applied to all rows (you can hide column E for one row and not another) ... the setup of your file would lead to me believe that your requirements are not viable.

[deeps1403]

Hello,

I dont mind, if I hide a particular column, all the rows would go hidden. All I need is , I dont want the unnecessary columns to be visible on selecting any option.

Thanks in advance,
deeps

[deeps1403]

Hello all,

Please help me on this issue.

Thanks in advance,
Deeps

[DonkeyOte]

Deeps, "bumping" your post inside 30 minutes is unlikely to get people to respond any quicker (quite the contrary).

You will need to utilise a Change event, below would reside in Sheet object - to insert right click on tab against which the code is to be applied - select View Code - paste below into resulting window.

Please Login or Register  to view this content.

You will of course need to add remaining conditions (you provided only three).

[deeps1403]

Hello Donkeyote,

Am sorry to trouble you again. I tried your code but it dint work. I have uploaded the sheet with your code below. Please advise.

the req is below.

Test case Creation : Show only E,P
Test Case Modification: Show only F,P
Test Scenario Creation: Show G, H
Test Matrix:I,P
Review:J,P
System Test:K,L,M,N,P
Retest:O,P
Other:P

Regards,
Deeps

[DonkeyOte]

The code does work I'm afraid - or at least it does what you asked... perhaps that's the problem ? ie you've since changed your requirements... you should be able to adapt the code to meet your own needs.

[deeps1403]

Hello,

I tried the code.Unfortunately it did not work for me.

When I open the sheet for the first time, I should not be able to see any of the columns from E to P

And I should be able to see appropriate columns on selecting options from Column C.

The code is not doing it for me. I fear i have done something wrong. Please check the sheet uploaded along with this. Code is pasted in it. Please correct me if I have done it wrongly.

Regards,
Deeps

[DonkeyOte]

Now x-posted: http://www.mrexcel.com/forum/showthread.php?t=414083

Deeps, I've not answered because put simply you have what you need to resolve your question you just need to put in a little effort on your side.

[deeps1403]

Sorry for the trouble caused. I tried to implement the code, but it dint work for me as am a beginner to excel macros.

Now x-posted: http://www.mrexcel.com/forum/showthread.php?t=414083

Deeps, I've not answered because put simply you have what you need to resolve your question you just need to put in a little effort on your side.

[deeps1403]

Please help me!!

Sorry for the trouble caused. I tried to implement the code, but it dint work for me as am a beginner to excel macros.