Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto Hide Columns & Rows
How can I hide 1 or more columns based on a cells value
For example, If there is an X in cell A1, column F will be hidden. If there is an X in cell A2, column F will be visible. If there is an X in cell A3, column G will be hidden. If there is an X in cell A4, column G will be visible. This could be triggered by a macro. I am using Autofilter for rows I am using Excel 97. Art |
#2
|
|||
|
|||
Are the values in A1 and A2 mutually exclusive? That is to say, if A1
= x then A2 does not ever = x? Same question for A3 and A4. If they're not mutually exclusive and you run a macro then the macro will unhide and hide columns while it's running, leaving you with inconclusive results. Do you need to consider just A1:A4, or does the information continue down to additional rows? |
#3
|
|||
|
|||
I was hoping either A1 or A2 have an x but not both.
The same for A3 and A4. I have approximatly 10 columns that I want to hide or un-hide. I was thinking of having associate text in B1 that may say hide column F If A1 has an x it means hide column F And associated text in B2 that may say un-hide column F If A2 has an x it means un-hide column F Another thought was to have radio buttons "Dave O" wrote: Are the values in A1 and A2 mutually exclusive? That is to say, if A1 = x then A2 does not ever = x? Same question for A3 and A4. If they're not mutually exclusive and you run a macro then the macro will unhide and hide columns while it's running, leaving you with inconclusive results. Do you need to consider just A1:A4, or does the information continue down to additional rows? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide / Unhide columns and rows | Excel Discussion (Misc queries) | |||
Auto Hide Columns | Excel Discussion (Misc queries) | |||
auto filling columns from rows | Excel Discussion (Misc queries) | |||
Auto update entire columns / rows??? | Excel Worksheet Functions | |||
AUTO HIDE ROWS | Excel Worksheet Functions |