Drop Down List Not Working As Used To Be ...

Feb 11, 2010

Something happened my excel sheet and my drop down lists are no longer working the way they used to. In the simplest terms I had two columns of data.

Column 1 "names" and column 2 is "years".

The top cell of each column had the title (i.e. name & year). These top cells used to have drop down lists with the little arrow. If I clicked on the cell Named "year" it would give me a drop down list of years. And if I clicked on a year in this list it would change the whole sheet to only display the data associated with the selected year.

View 2 Replies


ADVERTISEMENT

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

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 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

Validation In-cell Drop-down Not Working

Apr 22, 2003

I have set cell validation to use a named list and checked 'In-cell drop-down'. The validation works but the drop-down is not working.

View 9 Replies View Related

Created Validation Drop-down List - Can I Make The Row Now Change To The Colour That Relates To The Selection From The List

Jan 13, 2009

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?

View 9 Replies View Related

Drop-Down List: Generate A List Based On The Value Of A Cell

Jan 7, 2009

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.

View 3 Replies View Related

Drop Down List Defaults To Middle Of List

Sep 3, 2009

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 Related

Create A Sub List From A Drop Down List

Jan 26, 2009

I 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.

View 9 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 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

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

Self Updating Drop Down List

Nov 1, 2008

I 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

View 6 Replies View Related

Drop Down List Auto

Nov 3, 2008

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 Related

How Do I Create A Drop Down List

Dec 11, 2008

I 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 Related

Populate A Drop Down List

Jan 6, 2009

im 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.

View 10 Replies View Related

Drop Down List + Filtering

Jan 23, 2009

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.

View 7 Replies View Related

Drop Down List And Formula

Feb 21, 2009

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.

View 3 Replies View Related

Drop Down List For 2 Cells

Apr 5, 2009

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.

View 4 Replies View Related

Get Around The DV Drop Down List Limit

Aug 7, 2009

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 Related

Drop Down List With Pre Selected Value

Aug 25, 2009

My 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 Related

Drop-down List Formatting

Sep 2, 2009

I 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.

View 2 Replies View Related

Dynamic Drop Down List

Dec 7, 2009

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

Populate The Drop Down List

Dec 10, 2009

I have been using this formula in my report for a while now and i have just updated the table at which it looks at. The table consists of 3 columns - store, store number & division. The value at what vlookup looks for is the store and i have sorted this alphabetically.

But now when i choose the store from a drop down list i get nothing populated in the cell with the formula!!!

=IF(ISERROR(VLOOKUP(I5,$Z2:$AB$419,3)),"",(VLOOKUP(I5,$Z2:$AB$419,3)))

View 7 Replies View Related

Drop Down List In A Cell..?

Feb 13, 2010

I've created several dynamic range drop down lists and used DV procedure. They work fine, but when I drop down the list in a cell, the top item does not show. I have to scroll up to bring into view and select. How do I make the list show the top item.

View 5 Replies View Related

Drop Box To Have List Of Buyers

Jun 25, 2013

Just wondering if a drop box in excel can have a formula?

For example I want my dropbox to have a list of buyers i.e ASD, FDF, GSD

If I click ASD i would like the answer to use a formula to find out the volume they bought from a different spread sheet.

Is this possible?

View 3 Replies View Related

Drop-down List At Login

Jul 16, 2008

I have an excel file where different people have to make their comments. So far I have sent out the files on email and they sent it back and then copied their comments to the original file, but from now on I would like to share the file and let them to write in their comments.

In order to make it professional I would like the file to work as following (lets suppose that I am Mr.X and I have to write my comments in row 2,6 and 9):

1. When I (Mr.X) open the excel file, there is a pop up message box with a drop down list saying: "Please select your name:"

2. In the drop down list I select my name (Mr.X) and I press OK.

3. Then I get logged in the file and I will see rows 2,6 and 9 only.

4. After making my comments I save the file and log out.

As for the example lets assume that there are 3 people who are making the comments. Mr.X /rows 2,6 and 9/, Mr.Y /rows 1,3 and 8/ and Mr.Z /rows 4,5 and 7/

View 14 Replies View Related

Drop Down List Isn't Transferring In New Row

Oct 30, 2008

I have a spreadsheet that has 5 columns. The first row is the Header row, the second row is for the data input, here are the columns:

Column 1: Company Name, I have a drop down list associated with this column.

Column 2: Sales Person, I have a VLookup function to check for the company name in Column 1 and fill in with correct Sales Person.

Column 3: Total Sale, Manual input.

Column 4: Commission %, I have a VLookup function to check Company Name and fill in the correct Commission.

Column 5: Commission, Basic function of Total Sale * Commission %.

I have a macro created that when run it will take all the information from row 2 and move it to row 3 and at the same time inserting a blank row 2 with the functions for me to fill out new information.

The problem that I am having are 2 things:

1: When running the macro the functions will get applied to the newly inserted row but the drop down list for the Company column doesn't.

2: I would like to be able to start typing in the company name i.e "F" and have it jump to the F's in the drop down list.

View 9 Replies View Related

Search Drop Down List

Feb 16, 2009

is it possible to search a drop down list for matching values?

View 8 Replies View Related

Drop Down List In Comments

May 7, 2009

I have code that adds comments to a field once the field has been changed. What happens is you right click the field, select a field that has been added to the right-click menu called FYI. After FYI is selected an InputBox() statement is used and a box appears for you to type comments. Then what you typed is added to the comments in the cell.

Is there a function like the InputBox that allows you to use a List Box instead. I have tried finding it but cannot locate what I think it is. This is probably simple but I can't think of anything. I guess I could create a user form that pops up but I thought this would be easier to just have a Dop list appear like the InputBox if there was a function already in Excel?

View 6 Replies View Related







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