Lists and dynamic ranges

[Robin]

I was wanting a list to be able to add items to already made lists.
It stated in instructions that a dynamic range would allow this.
Also, have found on this site that there is not difference if the version is
2003 or greater.
I do not know how to check of adding to the list.
Also I thought I had created a dynamic list and do these list show up in
the upper left hand corner with the other list. In tyhe instructons that I
printed from Debra's site it stated that you had to type it in. I thought I
had created one and it did show up with the other list names ; however, I
tried to create other ones and did not see it show up in the List selection
and tried to recreate it and it stated that the name had already been used.
It also said in the instructions that you would have to type it in for the
range to appear; however, I am unsure where to do this.

 

[Luke M]

How are you defining your ranges? If you are simply selecting a range of
cells, and then typing a name into the box in upper-left corner: yes, you'll
be able to use the dropdown there to "see" your range.

However, dynamic ranges require you to use Insert-Name-Define. YOu need to
create an appropriate name, formula defining what cells you want, click
'add', then hit 'ok'.

For both scenarios, you use the range by literally typing the name. I.e., if
you have give the range A2:A10 the name "MyRange" you can type in B2:
=SUM(MyRange)
and it will give the sum of A2:A10.