Data Entry and maintaining NAMES

[Bradley M. Small]

I have a series of worksheets that have names for most columns up to a SUM()
when I want to enter more lines as long as I do an insert before I get
started the names maintain their range with the expanded rows included. On
other sheets I make use of these names for many different calculations.

What I would like to do is automate the process of ever increasing ranges by
some process so that someone using it doesn't risk accidentally either
breaking the ranges or overwriting the sum() calculations etc.. Even if I
just had one area to do the data entry and it was placed into the
appropriate location with insertion to effect the range expansion that would
be nice.

Am I trying to do something that is odd here?

 

[mzehr]

Hi Bradley,
Check out Debra Dalgleish's web site:

http://www.contextures.com/xlNames01.html#Dynamic

Also, you might try using the offset feature in your sum.
For instance I often use this formula =SUM(D7:OFFSET(D21,-
1,0)) placed in cell D21, so that if anyone enters a row
directly above the formula, it will automatically adjust
to pick it up.

HTH

 

[Bradley M. Small]

Wow what a great site!
I will no doubt spend some time there!