Adding/Removing Rows Automatically.

G

GEM

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

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

Similar Threads

Automatically insert new rows 2
make excel copy a row and automatically insert new rows 2
Deleting blank rows with formulas in them 7
My spreadsheet in some cases automatically adds a row below how? 5
Summing rows based upon condition 2
Automatically adding additional rows 3
Easiest Way to Delete Rows 4
Automatically color merged cells 1

Top