Computers & Internet Logo

Related Topics:

J
Jason Ghulam Posted on May 06, 2016

I have a drop down list of IT platforms and based on what the user selects I want to create another drop down in another column.

The problem I have after creating this is I only want the 2nd dependent drop down to be based off of one selection in the first dropdown i.e. user selects Spectrum in first drop down, they then go to the next column and the drop down I want to do is if Spectrum selected in Column A give them a second drop down list of 48K or 128K, else if not Spectrum they can enter anything they want

3 Related Answers

Bubbabear64

Tim Babcock

  • 2794 Answers
  • Posted on Sep 17, 2008

SOURCE: I created a drop down

If you build a query based on the drop down list in the report, you can do it that way.

Ad

Anonymous

  • 1 Answer
  • Posted on Sep 29, 2008

SOURCE: using drop-down form field in a word 2007 template

You need to protect the form (Protect Document, Editing Restrictions (Filling in Forms) then Start Enforcing Protection, the drop down menu will then work.

Anonymous

  • 286 Answers
  • Posted on Jun 14, 2010

SOURCE: what is formula to use 5 point drop down list to fill specific ce

In the cell where you want the data to be stored use the =cell formula
for example =CELL("contents",A2). now A2 is where your dropdown list is. put this code where you want the data to be stored.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
1answer

How to get CC on Harmony 650

You can do this by setting up a sequence on your Harmony remote. A sequence allows your Harmony remote to send up to 5 commands with one button press.

To create a sequence, follow these steps:

Click Customize Buttons beside an Activity
Click Add Sequence
Give the Sequence a name
Select the device(s) and commands that will be included in the sequence
Click Add another Sequence to append additional sequences to the list
Click Done
Sequence will now appear as a selectable item in each drop down menu in the Device column
If Sequence has been selected in the Device column, all the Sequences that have been created will appear in the Command column
Select a Sequence
Click Done
Click Update Remote to download these changes into your remote
tip

Excel - Drop Down List Ever wish that you didn't have to type...




Excel - Drop Down List

Ever wish that you didn't have to type out the same thing over and over again? Well you can save time by using Excel's drop down list!


Drop Down Preparation

Imagine that we are creating an Excel spreadsheet to document our purchases from the grocery store. For each purchase we want to mark down the name of the food and the type of the food.
The way a drop down list works in Excel is that it takes values from some place on your spreadsheet and uses them to populate the options in the list. Lucky for us, the type of food is a perfect opportunity to use a drop down list!
In cells A1 through A7 enter the type of food that will be used for the drop down list.


Creating a Drop Down List

Now that we have a source for our drop down list, we can create a begin to create our drop down.
1. Select cells D2 though D20 (We will be creating a drown down list for each cell in this range)

2. Click the Data menu and select Validation
3. Choose List from the Allow drop down menu

4. Click the Source button that appears to the right of the textfield

5. Select our source cells A1 though A7

6. Press Enter and Click OK

Testing Your Drop Down

All of your cells in the Type column should now have a drop down list. To test to see if your drop down works, click on cell D2 and then click on the downward facing arrow and see if all the types of food are available.

0helpful
1answer

Video controller driver VGA compatible is missing

Click start control panel administrive tools computer management device manager scroll to display adapters + to expand you might see a yellow question mark ? or exclamation mark ! or a red x right click select reinstall drivers

cnetdownload.com on the home page you should see the download software finder under that there will be a list platform, category sub category price from the category drop down list select drivers then from the price drop down list select free or which ever applies to your need
http://majorgeeks.com/SiS_UniVGA5_Graphics_Driver_For_Windows_7_d6264.html This package consists of SiS VGA Drivers, AGP Drivers, VGA Utilities, and Installation for Windows 7. Utilities include Control Center and SiStray. The Control Center provide some settings like gamma correction, video, TV output, driver mode, screen rotate, and product information. The SiStray provide Control Center entery and some settings like resolution, refresh rate,and rotation. The Installation are capable of installing/uninstalling drivers and utilities respectively.
Supported Chipsets:
SiS671, SiS672, SiS671FX, SiS672FX, SiSM671, SiSM671MX, SiSM672, SiSM672MX cnetdownload.com on the home page you should see the download software finder under that there will be a list platform, category sub category price from the category drop down list select drivers then from the price drop down list select free or which ever applies to your need hope this helps

3helpful
1answer

Mercury Motherboard Model PVM7 v3.1 VGA Driver For Winows7 Please Request For Link

Click start control panel administrive tools computer management device manager scroll to display adapters + to expand you might see a yellow question mark ? or exclamation mark ! or a red x right click select reinstall drivers
cnetdownload.com on the home page you should see the download software finder under that there will be a list platform, category sub category price from the category drop down list select drivers then from the price drop down list select free or which ever applies to http://majorgeeks.com/SiS_UniVGA5_Graphics_Driver_For_Windows_7_d6264.html This package consists of SiS VGA Drivers, AGP Drivers, VGA Utilities, and Installation for Windows 7. Utilities include Control Center and SiStray. The Control Center provide some settings like gamma correction, video, TV output, driver mode, screen rotate, and product information. The SiStray provide Control Center entery and some settings like resolution, refresh rate,and rotation. The Installation are capable of installing/uninstalling drivers and utilities respectively.
Supported Chipsets:
SiS671, SiS672, SiS671FX, SiS672FX, SiSM671, SiSM671MX, SiSM672, SiSM672MX cnetdownload.com on the home page you should see the download software finder under that there will be a list platform, category sub category price from the category drop down list select drivers then from the price drop down list select free or which ever applies to your need hope this helps

2helpful
1answer

My ATI Radeon 1250 Xpress does not appear to be compatible with the Windows 7 32 bit I have installed in my Samsung R60plus laptop. Can I update the card or do I have to buy a new one?

cnetdownload.com on the home page you should see the download software finder under that there will be a list platform, category sub category price from the category drop down list select drivers then from the price drop down list select free or which ever applies to your need http://ati-catalyst-drivers.en.softonic.com/ Optimise your ATi graphics card's performance. ... and save profiles for Direct3D and OpenGL applications ... CATALYST 3.8 adds new features and advanced, customizable options to ATI's industry-leading unified software suite. Gameplay, multimedia, 3D applications are extended with new technologies and customizable environments. These features all benefit from intuitive settings, beginning with a user-friendly 3D control panel. The 3D Control Panel makes adjusting 3D settings easier than ever, allowing users to create and save profiles for Direct3D and OpenGL applications. Custom sections of the control panel can now be used to individually configure 3D settings such as anti-aliasing, anisotropic filtering and SMARTSHADERâ„¢ effects. These additions enable gamers to activate exciting pixel shader effects in any... hope this helps

0helpful
1answer

Vga driver Problem

cnetdownload.com on the home page you should see the download software finder under that there will be a list platform, category sub category price from the category drop down list select drivers then from the price drop down list select free or which ever applies to your need http://majorgeeks.com/SiS_UniVGA5_Graphics_Driver_For_Windows_7_d6264.html
This package consists of SiS VGA Drivers, AGP Drivers, VGA Utilities, and Installation for Windows 7. Utilities include Control Center and SiStray. The Control Center provide some settings like gamma correction, video, TV output, driver mode, screen rotate, and product information. The SiStray provide Control Center entery and some settings like resolution, refresh rate,and rotation. The Installation are capable of installing/uninstalling drivers and utilities respectively.
Supported Chipsets:
SiS671, SiS672, SiS671FX, SiS672FX, SiSM671, SiSM671MX, SiSM672, SiSM672MX hope this helps cnetdownload.com on the home page you should see the download software finder under that there will be a list platform, category sub category price from the category drop down list select drivers then from the price drop down list select free or which ever applies to your need
hope this helps
0helpful
1answer

Excel

Hey dude,

Select both the columns and click on Auto-filter option. This will give you a drop-down list box to select data of your choice.

0helpful
1answer

Excel

Would you not be better off with a pivot table ?

To use multiple drop downs - each listing would need to be associated, or have a column that causes a relationship.
When selection 1 is made - a formula will dictate what fields to make visible (available) in the next menu..
you could build a macro in that will 'lift' the formulised data, and 'paste as values' it into a control area that will then give you a definitve second list based purely on the initial drop down.

Hope this makes sense
Not finding what you are looking for?

134 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...