Data Validation and named lists
 

I followed the instructions and it works great. Unfortunately, I have to add
a few items to my named list. I did that and re-selected the new list, named
it the same name and the drop down doesn't have the new items. What do I
have to do to update the named list? Also, how can I get it to allow more
than one selection (the old control click or shift click?)
--
Thanks in advance for all your help. PGP

Data Validation and named lists
 

Use a dynamic named list

=OFFSET($M$1,,,COUNT($M:$M),1)

as an example. This will cater for any additions.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"PGP" wrote in message
...
I followed the instructions and it works great. Unfortunately, I have to
add
a few items to my named list. I did that and re-selected the new list,
named
it the same name and the drop down doesn't have the new items. What do I
have to do to update the named list? Also, how can I get it to allow more
than one selection (the old control click or shift click?)
--
Thanks in advance for all your help. PGP

Data Validation and named lists
 

Here's how I do it:

For example, On a 'Lists' worksheet, Asuuming a list is in cells F5:F9, the
list has the following definition:
(Insert-Name-Define)

Listname is 'StatIcon'
The Refers to: =Lists!$F$5:$F$9

On the other worksheet the cell validation is:
Settings:
Allow: List
Source: =StatIcon

Now if I click on a cell in the list, THAT IS NOT THE FIRST ONE, then right
click and hit 'Insert' and 'Shift cells Down', I have a new entry where I can
add a new item to the list.

Note that there is a concept of a global list and local list. In the 'Define
Name' dialog box if you see a Sheet name in the list to the right of the list
name, then the list is LOCAL to the worksheet. Otherwise it is global and
visible to all worksheets.

I got bit by this and I'm still trying to sort it out. I'm not completely
sure if this is exact, but I think if you delete the local list in the Define
Name from the worksheet that doesn't contain the list, then the global one
should be visible again.

"Bob Phillips" wrote:

Use a dynamic named list

=OFFSET($M$1,,,COUNT($M:$M),1)

as an example. This will cater for any additions.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"PGP" wrote in message
...
I followed the instructions and it works great. Unfortunately, I have to
add
a few items to my named list. I did that and re-selected the new list,
named
it the same name and the drop down doesn't have the new items. What do I
have to do to update the named list? Also, how can I get it to allow more
than one selection (the old control click or shift click?)
--
Thanks in advance for all your help. PGP