Data List

M

mjs59

In relation to an earlier question, I am looking for a way of creatin
box which displays the contents of a list, which when clicked on can b
copied to a current cell, but other items added to this list.

For example, in one spreadsheet a list of;
John
Paul
Peter

In another spreadsheet, a view of this, so that the values can easil
be copied over, but also the abaility to add another name.

Something like..

[Players]
| John |
| Paul |
| Peter |
...
[ADD NEW]

Any ideas?

Many thanks,
Mic
 
J

John P

Mich

Lookup data validation.

It is very straightforward and easy to creat.

HTH.


John
 
D

Debra Dalgleish

You can use Data Validation to create a dropdown list. There are
instructions in Excel's help, and here:

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

You can use a list on a different sheet in the workbook, if you name the
range of cells that contains the list. To have the range expand
automatically as new items are added, you can use a dynamic range. There
are instructions here:

http://www.contextures.com/xlNames01.html
In relation to an earlier question, I am looking for a way of creating
box which displays the contents of a list, which when clicked on can be
copied to a current cell, but other items added to this list.

For example, in one spreadsheet a list of;
John
Paul
Peter

In another spreadsheet, a view of this, so that the values can easily
be copied over, but also the abaility to add another name.

Something like..

[Players]
| John |
| Paul |
| Peter |
..
[ADD NEW]
Click to expand...
 
M

mjs59

Thanks very much for the help. I have got the dynamic validatio
working.

I may have missed it, but is there a method of, when in a cell wher
data validation is being used, if a new value is entered, this is the
automatically place onto the other sheet, and hence the list?

Many thanks,
Mic
 
Top