| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding columns based on cell contents
I am looking for a solution to hide row or columns in a worksheet based upon
a value in a cell of another worksheet. To be more specific, I have a "setup" worksheet, with a column if entires. I have a second worksheet, "checklist" that I would like to format according to the entries in "setup". If setup:A1 is empty, I want to hide columns checklist 1-3 If setup:A2 is empty, I want to hide columns checklist 4-6. ANy ideas how to set this up automatically ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding rows or columns based on cell contents | Excel Discussion (Misc queries) | |||
| Hiding columns based on row 4 criteria | Excel Worksheet Functions | |||
| Hiding columns based on value | Excel Programming | |||
| hiding rows based on cell contents | Excel Discussion (Misc queries) | |||
| Hiding Columns based on value from another worksheet | Excel Programming | |||
![Bill H[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
