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.
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 RelatedI 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 RelatedI am trying to figure out how to build a drop-down menu with VBA that has 2 built in choices, 'call' or 'put', and based on the selection in the drop-down list (call or put), the value in the cell directly to its left will be 1 (if 'call' is selected) or 2 (if 'put' is selected).
I have tried doing this with the data validation tool, but the problem I have run into is that I do not want to store the items in the drop-down list (call or put) anywhere in the excel sheet.
I have a sheet with a drop down list. When a user selects a value from the drop down list the sheets field's are populated. I would like to make a macro that iterates through all of the values in the drop down list and for each time it does this print the sheet. So will have the full sheet printed for each value in the drop down.
View 4 Replies View RelatedI have created a drop down list of various material sizes what I am needing to do is to select a material size from the drop down list and a corresponding value is input into the cell. So on say sheet two (Data Sheet) I have Cell A1 25x25 with Cell B1 100, Cell A2 30x30 with Cell B2 120 and so on. On sheet 1 Cell A1 has my drop down list being the material size ie 25x25, so what I need to happen is if I select 25x25 then Cell B1 is 100 or if I select 30x30 then cell B1 is 120.
View 4 Replies View RelatedOk what I am trying to do is lookup a value in a table (kinda like one below but alot bigger). What I plan on doing is creating a drop down list for the rows that show "A, B, C etc) and then another drop down for (AA, BB, CC etc).
So lets say the 2 drop-down list are set to C and BB
I want to be able to fill another cell with the value -134
I would use If statements but like I said the table would be alot bigger than example. If possible I would rather not use VBA due to work security settings.
a b c
AA-110-110-129
BB-115-115-134
CC-117-133-136
i had a list based on dynamic formula.When ever i update(Add or Delete) New items to my List the drop down list should also be updated and sorted in Alphabetical order(Ascending :Words Starting with A - Z). How do i remove the blanks in the drop down list whenever i delete the data in the Source Data.
View 3 Replies View RelatedI want to automatically set default values in a row dependant on the value chosen in a list. Some of the default values need to be lists where the user can chose to update to a non-default value.
I have tried using a double drop down list. However if the default list value is changed then the dependant list value is changed, the default list is not automatically updated.
i have a list which is populated with data from another sheet.. if there is no data in the corresponding cell on the other sheet then the cell is blank.. i've tried using:
=OFFSET($Z$2,0,0,MATCH(REPT("z",255),$Z:$Z))
but it doesn't see the blank cells as blank i.e. no data in them as they contain formula's.. (even although there are no values populated) - can anyone offer any help in relation to this???
I am trying to create a fairly simple spreadsheet with about 8 columns and about 400 rows. One of the columns features a drop-down list with about 8 or 9 different options. Dependant on which option is selected, i would like the entire row to change colour with that option.
For example:
FAILED - whole row changes red
SUCCESSFUL - row has no fill
Tested - row changes to orange
etc.
Is this possible within Excel 2003?
I am trying to generate a list based on the value of a cell. That list will then be used as the range for a drop-down list. Example: Cell A1 returns a value of 15
A drop-down list displays the values 1 through 15. Cell A1 changes to 20
Drop-down list displays the values 1 through 20. I assume I'll need a two-step macro to accomplish this but I can't figure out the logic to populate the drop-down.
why my drop down list defaults to the middle of the list when first clicking on the arrow that opens the list? I created an alphabetical list of all US airports but when I open the list, it starts at "D" instead of "A" which is the top of the list.
View 5 Replies View RelatedI need to create a 'sub' list from a drop down list.
I have 8 categories in a drop down list in column A, but i need column B to also have a drop down list of sub categories depending on what category is selected in column A.
And once column B is populated, i need column C to auto populate with a value. All data is stored on the spreadsheet.
I'm creating a spreadsheet to track orders as part of a project, the spreadsheet currently lists all the different options that can be ordered, it then lists all parts of the order, installation & setup etc.
However it is likely that not all of the options will be used.
What I would like to do is create a few drop down boxes for each option, if 'yes' is selected then the order tracking for that option shows below.
Example, the wants 'internet' so 'yes' is selected for internet using the drop down at the top of the page. Further down the page all the order tracking info is shown for internet. If 'no' is selected nothing is shown for interent.
Does anyone have an example of dependant drop boxes with illegal characters in them? Even just a teensy one... If I have an example I can manipulate I can actually see what does what... The several-paragraph-long explanation with descriptions of what's being referenced by what and where and why - isn't helping me any.
View 6 Replies View Relatedi 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.
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?
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 RelatedI currently have a drop down list in sheet 1 and the list is being refrenced from sheet 2
Lets say the drop down list is for fruits and my current list in sheet 2 has 4 items Apple, Grape, Mango, Peach.
Now this is what I need :-
1 ) lets say a user wants to enter Orange (which is not in the list ) he can still do so by entering it manually into the cell.
2) Once Orange is entered which is not in the LIST in sheet 2 then that new name gets added to the LIST in sheet 2 so that next time that name appears in the drop down list automatically. eg Apple, Grape, Mango, Peach, Orange [ but Items should not get duplicated eg Apple, Grape, Apple, Mango, Peach, Apple
I have Excel 2003 installed on the companies computers. Many people use an Excel file and I am trying to make their work easier. There is on command which has a dropdown list made by me. What I would like to find out is that is there any possibility to make Excel help the user to choose from the drop-down list (the list is quite big). Is it possible to select a cell in this column and type in the cell and then Excel help the user. I mean (this list contains country names in abc order) if the user types S and W then Excel auto-corrects it to SWEDEN. Can this be done with Excel 2003?
View 2 Replies View RelatedI do not know how to create a drop down list to ensure the user inputs only the values from that list. Once I figure this out I would love to add a drop down calender for a cell as well.
View 14 Replies View Relatedim trying to create a spreadsheet for different makes of cars, here is what i want to do.
in cell one i want a drop down list for various makes of cars, in cell 2 i want another drop down list for the different models from that manufacturer (depending on which on I choose in cell one), in cells 3 and 4 I want different information depending on the make an model of the car. I have got 1 sheel with all this info on it but I dont know how to make it all work nice and neatly with drop down lists.
i m kinda playing with the drop down list and i decided to make a list about the nba teams.
heres the breakdown:
1st row
conference: east/west
2nd row
east: ATLANTIC/CENTRAL/SOUTHEAST
west: SOUTHWEST/NORTHWEST/PACIFIC
3rd row
the teams list is next.
now ive learned how to do a drop down list but i cant find a way to filter the 2nd row. i hope you can gimme some tips or ways on how to go over this. i tried data>filter but thats not what i need.
here is an attachment and i used sheet 1 for the input and sheet 2 for the list of the selections.
I have created a drop down list as follows
Whiteboard 16mm
Colourboard 16mm
Colourboard 18mm
Veneer 18mm
Veneer 19mm
Veneer laid up 40mm
Painted 16mm
Painted 18mm.
When I select one of these items I need CELL A1 to return just the thickness. EG: I hit dropdown list and select Whiteboard, CELL A1 then displays 16mm. Or I select Veneer laid up and it displays 40mm. I would imagine this formula would be quite long as I would have these 8 items in it.
I have a form with 2 columns. in the 1st, we have the product and in the 2nd, we have the price.
I have my drop down list for column1 but I want column 2 to show the correct price when column 1 has a product.
in the attached spreadsheet I have multiple sheets. On the tab "Tech IDS", column A is named "Name" and column B is the tech ID that is associated with the name in column A. Column B is validated as List=Name. Now under the tab "CAL Form" under Column A I need to type the tech's name. Now under the tab "CAL SHEET TEMPLATE" the name that I typed corresponds with a given cell (i.e. B2='CAL Form'!A2). Notice though that I2 does not give a tech id b/c of DV dropdown list meeting its limit. Look at I68, Bob's id appears b/c he fits within the limits. My question is... how can I still use the list with more names or can I modify the formula (=INDEX(ID,MATCH(B68,Name,0))) to include another Match search?
View 4 Replies View RelatedMy requirement is to implement a drop down list having two values "Yes (Recommended), No", I want the value "Yes (Recommended)" to be default value for all cells on which this validation is put. But also need a message box to be displayed if the user go ahead and select "No" the message box should be like "If you are not certain about this feature please click on 'Cancel' and contact you List Provider." and have 'Ok' and 'Cancel' button on it.
View 9 Replies View RelatedI am trying to use a drop-down list to alleviate errors in a worksheet but was wondering if it was possible to remove an item from the list once it was selected... Here is what I mean:
The drop down list shows:
Resume
Transcript
SAT
ACT
GPA
and there are five columns aside one another with these same options. What I want to know is if I choose resume for the first list, is there a way that I can make that option unavailable in the following four columns and show this:
Transcript
SAT
ACT
GPA
Or if I use any selection from the drop-down list, it would be removed from the other 4 columns.
I am trying to do a dynamic drop down. The left one is working fine, where as the right one is not. (see example) I just cannot get a complete list, even though I am using the same formula.
View 3 Replies View Related