Excel Lists

[818jaime]

Help

I have a few lists in one excel sheet and want to creat a formula o
something else in one cell that I can select from those lists and When
a list name (header) is selected it will display all contents in that
list and when I change and select a difrent name list it will bring
down all the items in that list.
So this will not be a drop down list but a drop down list name and it
will display all contents below.


Thank you

 

[Gord Dibben]

Looks like you need help on dependent Data Validation lists.

See Debra Dalgeish's site.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

 

[818jaime]

Looks like you need help on dependent Data Validation lists.

See Debra Dalgeish's site.

http://www.contextures.on.ca/xlDataVal02.html

Gord Dibben     MS Excel MVP







- Show quoted text -

Thank you.

 

[Roger Govier]

Hi

In addition take a look at
http://www.contextures.on.ca/xlDataVal15.html

--

Regards
Roger Govier

Thank you.

__________ Information from ESET Smart Security, version of virus
signature database 5782 (20110112) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5782 (20110112) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[WallyWallWhackr]

I went along a different route. I create named ranges, and then use a
cell as a pointer to each in the drop down spec.

This gives me a list based on the value of the cell that points to the
named range.

I have a time sheet that allows one to enter in 15 minute increments,
if another increment is selected, however, it lists the selected set.

I can bill on 1 minute, 2 minute, 10 minute, 15 Min, 20 min, & 30
minute breaks.

I have it posted on the Microsoft templates web site. It is an annual
task tracking workbook.

You select the increment from a small drop down, which lists
1,2,5,10,15,20,& 30 minute breaks. When you select one, the value of a
named range of one cell changes.

The drop down validation changes by way of the "INDIRECT" function.

SO, my named ranges I want to be drop down lists are given names like
Hours15 or Hours10

My drop down entry is =INDIRECT("Hours"&TickNum) where "TicNum" is the
range name I gave to the cell where the increment selection takes place.

Sorry, but one cannot put both the selector element and the drop down
at the same cell location, so you will have to have a list to select the
list you want, and then a nearby cell where that list is offered up,
based on the value in the other choice point.

http://office.microsoft.com/en-us/t...crement-selection-revision-2-TC030008308.aspx

OR

http://tinyurl.com/4duop3t