adding to a group

[Kyle Smith]

Yesterday I posted on how to link data with other data with a drop-down menu.
I was able to do this, but I can't figure out how to add or subtract to
these groups.

Example
54" $20
60" $30
66" $40

So the lengths would be in the drop menu and the price would come up
correspondiing to the length. Now suppose I want to add another length and
price to these groups (72" and $50), how can I do this? I have the lengths
in a group called size. It seems I cannot modify the contents of "size"
What about eliminating one of the lengths? Thanks in advance.

Kyle

 

[JulieD]

Hi Kyle

you need to use dynamic range names as the source for the dropdown. Dynamic
ranges (what you're calling "groups") resize themselves as items are added
or deleted.

Debra Dalgleish has a good explaination on how to create these on her
website at www.contextures.com/tiptech.html

Cheers
julieD