Excel Lists


8

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
 
Ad

Advertisements

R

Roger Govier

Hi

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

--

Regards
Roger Govier

818jaime said:
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
 
Ad

Advertisements

W

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top