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
ADVERTISEMENT
Jun 1, 2006
I have a list of cells i want to select my information from and in addtion i want to select the list all except one value in a box:
eg......
Value in Box: C
List of Values:
A
B
C
D
E
F
G
Therfore i want in a validation list all the values (A - G) except the value represented in the box, hence (C).
View 9 Replies
View Related
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
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
Jan 17, 2007
i have a drop down on my sheet, with this input range: $F$1:$F$4000
but when i make filtering for my data, the drop down keeps all the list from f1:f4000, is it possible to get the drop down show only the items after filtring ?
View 9 Replies
View Related
Nov 25, 2008
One sheet will be where someone will be able to select the filtering criteria from a drop down box (ie. Industry, Company, Location, etc) then click an execute button.
Then the macro will go to the second sheet where all the data is, filter the data and create a new spreadsheet with the selected data.
I have been able to create a filtering macro on the data sheet but have not been able to place the macro on the first sheet and have the macro run correctly. I have attached the file.
View 2 Replies
View Related
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
Nov 10, 2008
I have a list of email aliases for my company, approx 10,000 entries, mapping the alias to an email address. Two columns, one the alias firstname.surname, second column being the full email address. I have a second list, a subset of these aliases, approx 1200 of them, that are users of a particular web app. All i have in this list though, is the firstname.surname bit.
What I need to do is compare the lists, and where the aliases match I need to pull out the corresponding full email address from the long list, so I have 1200 aliases in the shorter list, with the full email address mapped to it. Is this possible in excel? i've tried all sorts of LOOKUP functions, and MATCH functions, but none seem to work. MATCH will give me the corresponding row number in the long list, but then it seems to offset itself every row it goes down, so the values are 1 out for every row. First row is good, second row -1, third row -3, fourth row -4 etc.
I don't want to have to manually go through 1200 entries and match them against a 10,000-entry list. Hopefully there's a quick way in excel to filter the long list down to the entries specified in the short list?
View 3 Replies
View Related
May 28, 2009
I am trying to create a sub-list from a master list based on a column criteria.
Basically, we have a large group of people that are now being split into 3 different sub groups, but still part of the whole. I would like to only upkeep the master list by assigning one of 3 managers to each employee and then having Excel place the employee's info (5 columns) into a seperate worksheet based on the manager assigned (3 seperate worksheets, one for each manager). I have searched through books and Excel help, but still cannot find any formula that can return multiple lines based on one criteria. Am I out of luck and forced to maintain this database with an Auto Filter and manually moving/copying the info?
View 5 Replies
View Related
Feb 2, 2007
to dynamically filter a list as shown below
View 9 Replies
View Related
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
Sep 19, 2008
I'm working out some vba script, that could filter up to 300,000 rows long list.
here is sample from that list:
1000999999027FRESH PASTA FETTUCINE WITH TOM102002P N0809100000035000000012810000000+0000000+ 0000000000000000+0203001896409
2000999999027020300189640900000000000005740200070063
1000999999027FRESH PASTA FETTUCINE WITH SPI102002P N0809100000025000000015700000100+0000000+ 0000000000000000+0203001896454
20009999990270203001896454000000000000057010180265125740200070070
As you can see, the rows are starting with 1000 and 2000. And that would be the criteria.
I'm importing the loooooong list file onto sheet1, and i'd like to sort the list so it puts all the codes starting with 1000 onto sheet2 and rows starting with 2000 onto sheet 3.
With regular filtering mode it's impossible and keeps giving errors.
I know it's possible, but i can't figure it out anymore.
I was thinking about to make script that would copy one row from sheet to sheet and loop it. But my mind just crashes doing that.
View 9 Replies
View Related
Nov 27, 2011
I have a pivot table with a group # on the left, and team members on the right. There are multiple team members in each group, and each are on a separate line in the pivot table, like this:
Group #Team1chrisdawnsally2cassiechrisdawnkathysally3jimjoejohntomGrand Total
I need to find where "sally" is on the team (easy to do"), BUT I need to display the rest of the team members in the group with her, like this:
Group #Team1Sally, Chris, Dawn2Cassie, Kathy, Sally, Dawn, ChrisGrand Total
Using the concatanate function to put them all into one cell and then filtering for "contains" was all I could come up with, but there are 14,000 groups
View 2 Replies
View Related
May 22, 2014
I also have a user form with two listboxes, a fruit box and a veggie box. I want to populate each box based on its type. So all of the fruits go in the fruit box, all the veggies in the veggie box. I have each column as a named value (lstKeys, lstTypes, lstName).
Code:
'Add Names
For Each Name In Range("lstNames")
If Range("lstType").Value = "Veggies" Then
[Code]....
View 1 Replies
View Related
May 28, 2014
I've got two long columns of dates and names. The dates and names can repeat. Eg:
01/01/14
Fred
01/01/14
Joe
01/01/14
Tom
[Code] ........
I want to input a date and create a list of names with only the names from the date I enter and earlier, and excluding names that appear again with a later date.
E.g. if I enter 01/01/14 I'd get:
Joe
Tom
But not Fred, as although he appears on 01/01/14 he also appears with a later date too.
View 3 Replies
View Related
Jan 9, 2007
I need to filter a list without the use of the Auto Filter or arrays. I'm importing the list into Xcelsius which doesn't support these functions. I will need to do the filtering with functions.
View 9 Replies
View Related
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
Jun 10, 2014
I have a long list of accounts (for the purposes of of bookkeeping - keeping a cash disbursement journal) and I use data validation that uses this list when I enter an account's name in the journal. Because the list is very long, I often times have to scroll up and down the list in the drop down menu that comes up at a cell I need to populate and when looking for the proper name of the account I needed to be there. I am looking to add a capability to my data validation list use when I would be able to enter several symbols, part of the name of the account I am looking for, and the list of accounts displayed for me to choose from would get shortened based on the symbols I enter. the symbols I enter do not necessarily have to be the first symbols of the account name I am looking for. (as sometimes, I do not remember how exactly the account is called - and so I just guess part of the name ... )
View 10 Replies
View Related
Mar 24, 2009
I have a list of 800 fund names that can be any one of 6 types of funds. It is easy to filter the names using the filter function, but I cannot get it to be a filtered list for my dropdown box. The dropdown box should only list those fund names of funds that is of a certain kind. I know I am missing something small.
If the accompanying data is used as an example, I would like a dropdown box with the names of all the I funds.
View 2 Replies
View Related
Sep 26, 2011
I'm trying to filter a list between two dates that are selected using drop down lists in Cells CZ1 and CZ2.
The first part of the code works ok ie it filters the list by column 28 as "Shipped" only.
The second part is causing me trouble.
The third part sorts the list by date order based on column 48 and this also works ok.
Code:
Sub FilterTransactionDates()
With Sheet1
.AutoFilterMode = False
.Range("A1:CU1").AutoFilter
.Range("A1:CU1").AutoFilter Field:=28, Criteria1:="Shipped"
.Range("A1:CU1").AutoFilter Field:=48, Criteria1:>=Range("CZ1").Value, Operator:= _
xlAnd, Criteria2:
View 5 Replies
View Related
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
Aug 19, 2009
I have two Spreadsheets, lets call it Spreadsheet 1 and Spreadsheet 2.
Spreadsheet 1 has a list of partial employee names in column A.
Spreadsheet 2 has a list of 500,0000 full employee names in column A and their phone number in column B and address in column C through E.
Basically what I want to do is do a wildcard search for the partial employee name, so like lookup Spreadsheet 1' Column A's *name* in column A of Spreadsheet 2. Based on the number of matches. I want to insert that many blank rows underneath the partial employee name, and paste those matched rows there, then continue to the second partial employee name lookup and repeat the process.
This loop has to repeat 1000 times.
View 14 Replies
View Related
Dec 16, 2013
From a table like the one here, how can I generate a list (without spaces) of all the names only? Perhaps filtering by "Mr","Miss","Dr" or something? The result I'm after would be a column on a new sheet that ran:
Mr James
Mrs Milly
Dr McAllister
Miss Aujard
Mr Barker
Mrs Stanley
View 3 Replies
View Related
Aug 25, 2006
I have a list of a couple of thousand (and more) individual items. I want to filter the list and have a box for users to type in text (there are no numbers) and the results will be seen automatically reducing in number as more text is entered. (Similar to the Windows HELP files )
eg, typing A (or a) will show all entries beginning with A (without pressing
"Enter" or similar
typing AB will show only entries beinning with AB
typing ABO will show .........I guess you will understand the idea.
I have tried various forms of Filter - Auto and advanced - but still cannot get the spreadsheet to do what I want. Unless I am not doing the Autofilter (or Advanced filter) correctly (I am still a relative beginner!) I still cannot find a way of simply adding letters to a cell or input box and the filtering takes place 'automatically' as the letters are added.
View 8 Replies
View Related
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
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
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
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
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
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
