how do I create a drop-down list which is ordered from another table?

[Kashgarinn]

Thank you for checking out this post.. the subject is horrible, I kno
but I wasn't sure how to phrase it correctly.

Here's my dilemma: I have a table of data I call "tech_1" with
columns.

On another sheet, I want to be able to have 2 drop-down lists.

The first drop-down list gives me a choice of 5 names, which are 5 o
the columns in tech_1.

(this is the easy part, here comes the hard part)

Let's say I choose the name for column 3. In that column ar
statistics for items. Sometimes a cell's value is 0. The names of th
items are in column 1 of the tech_1 table.

In the second drop-down list I want an arranged list of all items whic
have a value in column 3, and have it in order from the highest value
to the lowest value. What's displayed in the drop-down list should b
the name of the item, which is kept in column 1 of tech_1 table.

I'm thinking that I need to make a new, hidden table which checks wha
is chosen in drop-down list 1, and then arranges things from highest t
lowest, and discards any 0 value.

However.. how do I do this? I have no clue what function I should use
and I have no real vba scripting experience.

Thanks for any replies.

K

 

[Don Guillett]

Have a look here for info on drop downs
http://www.contextures.com/tiptech.html

 

[Kashgarinn]

I've realised I might have confused people about what I'm asking.

The drop-down thing isn't what I'm asking about.. that's really th
end-product I want.

The thing I'm asking about is how do I create a table which grabs dat
from another table, and arranges it from highest value of one colum
down to the lowest and dicards the 0 value.

This is my real question.. it got tangled in the drop down boxe
because I want to be able to choose what column to re-arrange the tabl
to from drop-down box 1, and I want to display the result in drop-dow
box 2.

So forgive me for confusing the issue. The real question is how do
create a table which grabs data from another table, and arranges i
from highest value of selected column down to lowest.

The selection of a column is made in drop-down box 1.

The items names (which are in column 1) are displayed in drop-down bo
2.

Sorry about the confusion.

K

 

[Kashgarinn]

Double post :/

K

 

[Debra Dalgleish]

I've added a sample workbook to my web site that has two dropdown lists.
The first list is based on column headings, and the second list contains
unique items from the selected column, sorted in descending order:

http://www.contextures.com/excelfiles.html

Under the heading 'Data Validation'
Look for 'Create Dependent List for Selected Column'

An event macro runs an Advanced Filter when the value in the first
dropdown list is changed.