Auto row insert-remove

[tkredd]

Guru's: I have a report on tab sheet 5. I have cell calcualtions and templates on other sheets, say tab sheet 1,2,3,4. These other sheets may or may not be needed for a calcualtion. Separate sheets are needed for efficient screen size fonts and tablet picking.
Question: I need sheet 5 (summary report) to insert/remove rows based on utilizing the formulas and final calculation cells in tab sheets 1-4.
How is this report on tab sheet 5 made to do so?

 

[Tom Urtis]

Your question the way you asked it is impossible to answer from a distance.

First, the significance of this sentence is limited to only those people who can see your workbook:
"Separate sheets are needed for efficient screen size fonts and tablet picking."

Then, how to answer this question...
"I need sheet 5 (summary report) to insert/remove rows based on utilizing the formulas and final calculation cells in tab sheets 1-4."
...would depend on having some idea of your workbook design. And it's not clear of you want to insert or delete rows from Sheet5, or on all sheets except Sheet5 when something happens (an "event") on Sheet5.

Try explaining why rows should be inserted deleted, on which sheet(s) exactly, and with a scenario that exposes the logic of what you are doing at the point of expecting a row to be inserted or deleted.

Just too hard to tell what you want, and why, and under what conditions.