You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

How to limit columns that display based on selection of a dropdown value

How to limit columns that display based on selection of a dropdown value

Price: FREE

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

Visit publisher's web-site: How to limit columns that display based on selection of a dropdown value

Category and Tags: ExcelTutorials : : Functions

Related Tutorials

Display column based on dropdown

Free: Yes
Tags: Excel ›

I have column 1 with a dropdown field in a cell, columns to the left have dropdown field names like forumula1, forumula2,forumula3,forumula4
Below are rows with data.
Please see attached file to see what I mean. I tried using hlookup but it does not work.

Sum data based on selection on dropdown menu

Free: Yes
Tags: Excel ›

Need your kind help here. I have a several sheets containing actual, budget and forecast numbers and all in the same format. What I want is to display (sumif) the data based on the month chosen in the drop down list. e.g if I choose March 12, then all the numbers in actual, budget and forecast will display the sumif from the respective sheet.
Also is it possible to display the year to date amount?
Thanks for your kind help, attached is the sample data

Dropdown List within a dropdown

Free: Yes
Tags: Excel › Functions

I'm in the process of creating a spreadsheet containing many dropdown lists.
My need is to create a dropdown within the dropdown, based upon the entry chosen by the first drop down selection. Totally confused yet?
For example, if I select "Modem" from the first dropdown. I want to then be taken to another dropdown containing the names of all Modem Manufacturers from which the next selection would be made.

DropDown Selection in EXCEL 2007

Free: Yes
Tags: Excel ›

I need to know how to change a dropdown list collection based on a selection change in another dropdown.
I want to know if there is any setting to do the same.
I am ot looking for any code for this.

Lock worksheet, based on dropdown selection prior worksheet

Free: Yes
Tags: Excel ›

I am creating a workbook, where I have several worksheet that are labeled with the same first 7 characters "ab123 -".
The user selects one of these sheets from a dropdown in the first worksheet.
I provide a conditionally formatted hyperlink within worksheet A, based on their selection, but for quality control want an additional step that either locks an incorrect selection or presenting a msgbox to re-direct.
Can this be done?

Related Applications & Scripts

Menu Dropdown jQuery

Free: No

Multilevel submenus
Create dropdown menus
Supports div dropdown on
Customizable CSS
Works in all browsers
Show on top of flash content
Moving Box when mouse Hover
3 steps to install

AS3 Contact Form with Validation

Free: No
Tags: Flash › Excel Forms

This contact form lists all modules that you can use. By editing the XML file, you can enable modules such as: dropdown, textfield, checkbox and radio groups.
The validation is done based on the type of content the user has to add, such as a number or an email address. The user is requested to fill all fields, and if he tries to submit incomplete information, the strokes color changes based on the value you send in the XML.
Each item can appear as many times as you need, and the dropdown and radio group can have as many items as you need for each instance.

Contact form with DropDown menu

Free: No
Tags: Flash › Excel Drop Down Menus Forms

Very interesting contact form with DropDown menu you can modify it how ever you want because the code is very simple and easy to use.
Features:
- Custom subject message
- Collect IP Address of the sender
- Collect Browser info from the sender (browser name and version)
- Reply directly to the sender email address
- Check if all fields are filled
- Verify if @ is present in the email field
- Tab Index activated (when you hit tab to jump form field to field)
- DropDown menu (you can add or remove items from the menu)
- Reply the sent result (message sent or not sent).

Dynamic XML Zoom DropDown Menu

Free: No
Tags: Flash › Excel Horizontal Menus Menus

Dynamic XML Zoom DropDown Menu
Settings Through XML :
- As Many Number You Want
- Url(Main and Sub menu)
- Frame target(through framelabel and framenumber)
- You Can Load Swf(but the target movieclip has to be set in fla)
- Menu bars color for both main menu and sub menu(at the moment black)
- MenuTexts (white and black)
- Html Window
The whole code is commented line by line and a detailed help file has been provided.

InstaPics: Web based image gallery

Free: No
Tags: PHP › Excel Image Galleries

InstaPics allows you to create a web based "image gallery" for your site, allowing your visitors to upload their own images.
This can be used for a number of purposes, from a private gallery among friends to a public, free-for-all image library, to the foundation of a TGP site. Features 100% templates and allows you to limit the size of uploaded files.

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing