Hi everyone, I'm new and need your help,
I need help with a financial spreadsheet. I'm trying to build a financial spreadsheet to use on different types of projects. The problem I'm having is how to add new rows in the sheet for one project, and then delete or add more rows for another project.

Example:
Income
Row 1 is Sales
Row 2 is Services
Row 3 is Other Income
I need to be able to - Add new row here or remove a row

Expenses
Row 4 is Rent
Row 5 is Phone
Row 6 is Electric
Row 7 is Other Expense
Add new row here or remove a row

I would like to automate the row insert or delete a row if I like at anytime and not mess up the whole reports. If I change a row now, it will not remove the whole row and all my data gets messed up in the entire sheet. I need to be able to add and delete rows anytime or at any point and have the sheet make the adjustments. I can manually insert a row, but I can't remove it without messing up the sheet and the numbers. I used a program called business plan pro and it has a wizard style form to help me insert rows, but the program is not big enough for larger business planning projects.

Hope someone can help me?