Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
New User to this this site. Great site, have found a lot of great information.
Have not been able to find how to do this: I have a Worksheet that I want to limit the columns that display based on a value selected in a dropdown list. This sheet is a worksheet that data entry will be completed on. The worksheet currently only contains a header row. The value in the dropdown list only contains two values: ValueA, ValueB The dropdown list was created using data validation, Allow list, and typing in ValueA, ValueB. Column B Contains the dropdown list of ValueA, ValueB What I want to do is: If ColumnB contains ValueA, then display columns: A through H and K If ColumnB contains ValueB, then display columns: A through C, I and J How can I accomplish this? Thanks for the assistance as I am stumped. HRwilkers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto fill columns based on a selection | Excel Discussion (Misc queries) | |||
offer dropdown options based on another dropdown | Excel Discussion (Misc queries) | |||
Dropdown list key selection | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Dropdown selection crashes | Excel Worksheet Functions |