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???