Don,
Thanks for replying. I am tracking prices of about 20 different commodities,
and I have created a Data List so I can input more data in the future. After
reading your reply, either I was not very clear about what list I am working
with or you may have misunderstand what I meant by list. By using the
insertnamedefine...., I know how you can creat a list and then use
Validation for a cell so that list appears in a drop down box for the cell.
What I am working with is the list under the Data menu (the list that allows
you to sort data and expand the list via the * row). I have several charts
link to this list, and when I add more data to the list, the charts update
but all formatting is lost. Do you know how to preserve the formatting?
I hope this clears up the misunderstanding, and thanks for helping.
-JasenD
"Don Guillett" wrote:
more detail about what you are doing and how you are doing it. Perhaps you
need to use a defined name for your ranges that would be self adjusting.
Take a look at insertnamedefinename itin the refers to box type in
=offset($a$1,0,0,counta($A:$A),6) in the source
=yourworkname.xls!yourdefinedname
--
Don Guillett
SalesAid Software