Drop Down

May 3, 2009

i am trying to figure out how to write a formula and trying to figure out what type of formula to use to do this, been reading alot latley. i have a data verification drop down with many items in it. when an item is selected i want it to give two other responces in a selected column.
ITEMQUANTITYUNIT DESCRIPTION150ALF8" DI Water150BLF6" DI Water

what i am after is this. i open the data verification drop down for 8" DI Water, when that item is selected i want it to install the appropiet unit number that would be LF (lanier foot) and also input the item which is 150A. i have a list of 80 items all that have their own unit and item number. This would save me alot of time.

View 9 Replies


ADVERTISEMENT

What Its Called When You Have Drop Down Menus That Correspond With Other Drop Down Me

Nov 22, 2008

what its called when you have drop down menus that correspond with other drop down menus.

View 2 Replies View Related

Populate Drop-Down Based On Another Drop-Down Choice

Oct 25, 2006

Here is what I'm trying to do:

I have 4 sheets:
1 called main
1 called states
1 called counties
1 called people

On "main" I have 1 drop down box and 1 cell:

the drop down lists the states from "states" sheet
the cell, which i would like to have as a drop down is supposed to be listing the counties in the state selected from the 1st drop down. right now it is setting the value to TRUE for testing purposes.

then when the county is selected, it will display the people in that county listed in "people". So far I can only get the 1st drop down to list the states. that's the easy part. i need to getting the counties to list in another drop down based on what state is selected.

View 2 Replies View Related

Populate Drop-Down Based On Another Drop-Down Selection ...

Dec 5, 2007

Im a fairly basic VBA user who has just purchased the code for J-Walk's Enhanced Data Form.

On other threads in this forum I have noticed a lot of people asking how to make the contents of one drop-down box dependant on the selection in another. I am trying to do the same thing but with the criteria section of the EDF form.

Is this possible? What does give me hope is that a simple Autofilter - whilst not as aesthetically pleasing, does the job well.

View 3 Replies View Related

Populate Drop-Down Based On Another Drop-Down Selection

Aug 7, 2008

Currently I have columns fixed or assigned to the names of insurance providers/companies.

In each column below the name of the Insurance Company, a combobox containing the plans that company offers. Choose a plan, and the rest of the column is filled in using vlookup.

Now to save space, IE opposed to having 13-15 columns one assigned to each Insurance Company/Provider. I am looking to have only 3-5 columns with a first initial combobox in which one chooses the Name of the Company/Provider, and in turn populate the original combobox and vlookup functionality I already have built in.

Here is an example of what I am working with.
[url]

View 3 Replies View Related

Drop Down List Which Returns Values Based On What Has Been Selected In The Previous Drop Down List In The Adjacent Cell

Mar 19, 2009

I'm trying to create a drop down list which returns values based on what has been selected in the previous drop down list in the adjacent cell, e.g. if 'Apples' is selected in the previous cell then you should only be able to select from 'Gala, Granny Smith', or if 'Oranges' is selected you should only be able to select 'Seville, Blood Orange'. Is there a formula which would do this, or can I use a pivot table somehow? I'm totally stumped.

View 2 Replies View Related

Selection From One Drop Down Creates New Drop Down

Mar 1, 2007

In the attached example I am trying to get the selections from one drop down to gnerate available selections in the next. The first drop down is the door style. This then needs to generate the possible drop downs in wood species. This then needs to generate the possible drop down in available stains. this then needs to generate the related door factor....

View 9 Replies View Related

Drop Down List Which Displays A Different Set Of Values Depending Upon The Value Selected By A Previous Drop Down List

Oct 26, 2009

I need to have a drop down list which displays a different set of values depending upon the value selected by a previous drop down list. ie. (drop down box 1)= x, y, z. (drop down box 2)= either x1, x2, x3, or y1, y2, y3, or z1, z2, z3. I can produce a single drop down box thats not a problem but linking several drop down boxes is beyond me .

View 4 Replies View Related

Drop Drop Menus

Oct 5, 2009

I receive inspection sheets from mechanics and I need to start tracking trends. So, let's say the mechanic has marked an "interior" issue and of the 10 potential items that could related to "interior", he has chosen "dirty upholstery" -

Column A is drop down menu with four categories listed:

Interior
Exterior
Transmission
Undercarriage

So in Column A from the drop down menu I pick the main category of Interior. Then it's on to Column B to choose the exact issue of the Interior. When I choose "Interior" in Column A I would like Column B to automatically show me another drop down list with issues that relate only to Interior (i.e. glass, dirty upholstery, torn upholstery, etc.)

that is question #1....

If there are multiple issues on one vehicle, I would then go to Column C, pick another category (i.e. Transmission) and then in Column D, I would like it to automatically display the drop down menu that relates to Tranmission issues (engine oil, air intake, engine wiring, etc.).

View 4 Replies View Related

Drop Down List Values Dependant On Value Of Another Drop Down List

Dec 9, 2009

I have a drop down box in column N, however I would like the options in that drop down box to change depending on what appears in column M.

If column M Says "Lapse" then I want one drop down box to appear in column N, If coumn M says "NTU" then I would like column N to show different drop down options.

View 12 Replies View Related

Drop Down/ List Box

May 22, 2008

i have a spreadsheet with several fields. i want to derive information from this data. i want to be able to control the output through the use of list/drop down boxes.

so the user will choose several criteria AND based on this criteria, the ouutput will reflect user requirements.

View 12 Replies View Related

Drop Down Menus

May 22, 2008

I want to have a spread sheet where a user will pick an option from a drop down list, then based on that option choice, have a different cell populate with a specifc drop down menu.

Example:

Cell A1 has a drop down with three choices (1,2,3)
User selects option 1
Cell B1 will now have a drop down with options A,B,C
However:
If user selects option 2 from A1
Cell B1 will now have a drop down menu with options X,Y,Z

View 11 Replies View Related

Drop Down Not Recognising

Nov 24, 2008

i have a drop down list in cell b16 it has suppliers names in and it has several which are not all one word ie "monk and crane" the thing is that in cell d29 i have a drop down list that is dependant on whats in cell b16 in cell b16 i am using another data validation list using the code

View 2 Replies View Related

Drop Down Additions

Dec 20, 2008

if i have a drop down list of say 10 names

and i want to add a name to that drop down list is there anyway i can do this by just putting it in the input cell

eg if my dropdown list is in a1 and i need to select the name mark
mark isnt in the drop down list i can manually type this as i have unchecked input message and error message but is there anyway i can get a code to add that to the dropdown validation list the next time i open up i ask because i dont want people entering names on the sheet and having the name range changed

View 9 Replies View Related

Drop Down Box In A Cell

Mar 2, 2009

I'd like to have a drop down box in a cell in excel - so you would click on the drop down arrow and choose a name from the drop down. This name would then be displayed in that cell. The idea being that you can only chose a name from the list, and type nothing else in there.

View 2 Replies View Related

Lookup Name Changes From A Drop Down?

May 15, 2009

I have named six different sets of data with six different names. I have a drop down box that lists these six different names. When I select one of the names from the drop down box, I would like the lookup I have off of this to change to what ever set of data the drop down selection is referring to. Example: I have my first data set named "Data_A", next "Data_B", etc... When my drop down selects "Data_E", i would like my Hlookup equation to change to HLookUp(a1,Data_E,3,false). Is this possible, or am I doing something wrong?

View 4 Replies View Related

Drop Down In Userform

Oct 19, 2008

Upon click of "Populate Scorecard" button (e.g. on Company X worksheet), would like user to complete the Userform and based on their response, it would add to the appropriate "Month" (selected from the Userform Drop down) in the Scorecard worksheet.

I have started an IF statement for "Jan-08" and was going to copy and paste code for each of the months, e.g "Feb 08, Mar-08 etc", but thought their would be an easier way based on Loops or Call statement. Just not sure how to do this? Can anyone assist with getting me started?

I'm also not sure how to add the code for "Buyer Comments" and "Month" to be added to seperate worksheet (e.g. Company X), if Company X was selected.

Note that i will create a hide sheet statement, so user can select which Company (e.g. X or Y) to select from. The code would then need to correspond with that companies Scorcard worksheet.

View 14 Replies View Related

Drop Down With Numbers But One Is N/A

Nov 8, 2008

User form has a drop down with numbers but one is N/A
Example
5
4
3
2
1
N/A

Several identical user forms populate different cells on a work sheet

user forms are coded to allow the N/A

View 6 Replies View Related

Drop Down Box In Cells

Jun 16, 2009

I am trying to create a drop-down box in cells D21 and D22 which are dependent on each other. From my understanding this cannot be done in Data Validation. For example cell D21 is Route Number and D22 is Route name. If someone knows the Route Name they would select it from the drop-down, then cell D21 would fill in the Route Number. Similarly if they know the Route Number the Route Name would fill in.

I am able to have one dependent on the other using Data Validation and VLOOKUP, however not dependent on each other.

View 6 Replies View Related

Drop Down Box -Goto

Feb 13, 2010

I have a drop down box linked to cell A2 for example, when the change is made on the drop down box the linked cell returns the value 1,2or 3. I'm not sure if I require a code or an 'IF' command - but what I would like to achieve is that say when 2 is selected I want to goto sheet 3 A1, if 3 is selected then sheet 3 A2 and if 1 then nothing happens. Or can I make the function dependant on what the drop down box displays e.g Correct, Not Correct and Requires Change. (1,2 and 3 respectively).

View 3 Replies View Related

More Drop Down Menu

Jan 7, 2009

I can weld together a bare chassis, or a complete turn-key car, or anything in between. With that I am putting prices next to every option, and part n piece that goes on the chassis. This is fine when I choose welded chassis under car type and just add a few options to it.

However if I choose turn-key or even roller, there are items that i need to choose between like rear coilover manufacturer and what not, but I dont need to add that price in considering its already included in the turn-key price of $135,000.00

So my question is, if I choose bare chassis, can I leave everything the same, but if I select turn-key, can I make it so it does not include that price in the bottom total cost of the car?

View 3 Replies View Related

Drop-Down Box With A Calendar

Aug 2, 2002

Is there a way to set up a designated cell in a spreadsheet with a drop-down box that will have a calendar, so that when you click on a date in the calendar it puts that date in the cell?

View 9 Replies View Related

Drop Down Box Formula

Dec 4, 2006

if it is possible to have a drop down box of 2 or 3 options, and depending on the selection of those options, the cell behind the drop down box will change to a specified color, ie: red, blue, green

I figured using some sort of conditional formatting on the cell would work, however I do not know how to link the conditional formatting to the drop down box.

View 9 Replies View Related

Drop Down Box Disappeared

Oct 23, 2007

I have created some drop-down boxes on a tracking spreadsheet. Last week they were they today they are gone.

I went in and cleared the cells and re-created by dropdowns. I did remember to click, in-cell dropdown, but when I click on the cell it is not there.

Now if I right click on the cell it does give me an option to choose from a drop down. So my options are still there but why are they not appearing in the cell when I click on it.

I am using Excel 2003 with Windows XP

View 9 Replies View Related

Drop Down List Using VBA

Dec 1, 2007

I have a workbook with around 35+ sheets on it and I was wondering if its possible if I could put these sheets in a drop down list in say cell A1 so it would be easier to navigate the sheets. Is this possible with out using VBA code if so how would I go about doing it?

View 9 Replies View Related

Vba:Drop Down Box In Userform

Aug 18, 2008

A listbox is too big and take too much space. Can I have a drop down box instead?

View 9 Replies View Related

Drop-Down Box Toggle

Nov 12, 2008

Is there a way to keep the drop-box on a combobox from showing at all? I am trying to build one that has several different values that will just cycle through when clicked.

Here a bit of code I am using so far, just as an example:

Private Sub ComboBox1_DropButt*******()
If Range("F7").Value = "Yes" Then
Me.ComboBox1.Value = "No"
Else
Me.ComboBox1.Value = "Yes"
End If
End Sub

View 9 Replies View Related

Field Changes With A Drop Down Box

May 25, 2009

Spreadsheet A
Stock Name: This field changes with a drop down box i have created

Depending on which stockl you select it goes to Spreadsheet B to select data from column 2 based on date. In spreadhset B all the stocks are listed, so not only am i trying to lookup data but also return value in co,umn B for that particular stock i selected. So the idea is i can change the stock in teh drop down and then it will return the values i want.

View 9 Replies View Related

Create A Drop Down Box

May 26, 2009

creating a drop down box that will contain the names of all the worksheets in the workbook and on selecting a particular name it should go to the selected sheet.

View 9 Replies View Related

Add To A Drop Down List

Jan 13, 2010

I have a drop down list of shipping Companies. If the name of the company is not in the drop down list how do I allow the user to type in the name then have it save in the drop down list source?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved