I have the attached file. This will be one sheet in a large template. Range B10:B16 has formulas, and people will be entering data in range C10:I16. The problem with this, is some times, the template may only need a few rows, other times it may need 100 rows. Since formulas are in the table, I don't want people just inserting rows and coping down the formula, but rather have a button they push that automatically inserts a set number of rows (say 5) that copies down any formulas.
For example, I would like to push a button to add 5 rows to the table on the attached to change the table range from B8:I16 to B8:I21 with all formatting and formulas automatically filling in.
Can someone help me with this. Note, the technology I learn here will be used on multiple tables throughout the entire template.
Bookmarks