software

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

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)

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

quot;Bob Phillipsquot; wrote:

gt; Use a dynamic named list
gt;
gt; =OFFSET($M$1,,,COUNT($M:$M),1)
gt;
gt; as an example. This will cater for any additions.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;PGPquot; gt; wrote in message
gt; ...
gt; gt; I followed the instructions and it works great. Unfortunately, I have to
gt; add
gt; gt; a few items to my named list. I did that and re-selected the new list,
gt; named
gt; gt; it the same name and the drop down doesn't have the new items. What do I
gt; gt; have to do to update the named list? Also, how can I get it to allow more
gt; gt; than one selection (the old control click or shift click?)
gt; gt; --
gt; gt; Thanks in advance for all your help. PGP
gt;
gt;
gt;