Help With Named Lists

H

Heyna

Hi Folks;
Need help that may be real easy, but I'm losing it. I was working o
making Named Lists- selecting a range of data and typing in a "name" i
the name box, thereby giving a set range by grouping the list by name
These can then be refererenced in formulas- this came in handy with th
large volume of named lists I had to make to corral all my data.
The problem is probably obvious; I didn't include all of th
information necessary in the creation of the named list and, after fa
too much other work, I find I can't just change the named range b
highlighting an extra cell and re-typing the name. Is there a safe wa
to do this? Due to my poor planning, if I insert single cells too ofte
(more than one or two) i begin to change all my named ranges.
Haaalp!
Scot
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top