Sounds like you should check out "Dynamic Ranges"

See Debra Dalgleish's site for more info.

http://www.contextures.on.ca/xlNames01.html#Dynamic

But Excel will not "automatically" delete rows and insert formulas for you.


Gord Dibben MS Excel MVP


On Thu, 19 Mar 2009 15:42:01 -0700, GEM
wrote:

I'm trying to add/remove rows to a certain range of cells depending on the
number of people which are included. For example if the number of people
included are 10 I would like for Excel to automatically put 10 rows with the
formulas already set, if next time I have 8 people I would like for excel to
remove 2 rows and automatically leave 8 rows for me to work in.

Is this possible???