I am in need of figuring out how to hide columns based upon a cell value. The cell value is created by a control button/form to which there are 6 possible selections.
So based upon the value entered into the cell by the users selection I need to do the following:
If ax143 = 1 then hide the columns M:AV BUT be sure G:L are not hidden.
If ax143 =2 then hide columns G:L and T:AV but be sure N:S are not hidden
If ax143 = 3 then hide columns G:T and AA:AV but be sure U:Z are not hidden
If ax143 =4 then hide columns G:AA and AH:AV but be sure AB:AG are not hidden
If ax143 =5 then hide columns G:AH and AO:AV but not AI:AN
If ax143 =6 then hide columns G:AO but notAP:AV
I have tried doing this every way I can think of and I've not been able to stumble on the correct solution so I'm begging someone to please put me our of my misery and tell me how to do it.
I have nearly zero skills in this area, this is the first time I've ever tried to do this in Excel, and so far I'm at a complete loss.
Thanks for help
So based upon the value entered into the cell by the users selection I need to do the following:
If ax143 = 1 then hide the columns M:AV BUT be sure G:L are not hidden.
If ax143 =2 then hide columns G:L and T:AV but be sure N:S are not hidden
If ax143 = 3 then hide columns G:T and AA:AV but be sure U:Z are not hidden
If ax143 =4 then hide columns G:AA and AH:AV but be sure AB:AG are not hidden
If ax143 =5 then hide columns G:AH and AO:AV but not AI:AN
If ax143 =6 then hide columns G:AO but notAP:AV
I have tried doing this every way I can think of and I've not been able to stumble on the correct solution so I'm begging someone to please put me our of my misery and tell me how to do it.
I have nearly zero skills in this area, this is the first time I've ever tried to do this in Excel, and so far I'm at a complete loss.
Thanks for help