Automatically Add/Delete rows based on user input but check current table row count

I am Using Windows 7, Excel 2010.

My usage of VBA is VERY VERY minimal. I barely know how to navigate.

This might get confusing so I am going to be as descriptive as possible.

Overall Goal = I want to add a row within a table (if a row needs to be added), based on a user input.


I currently have a table of data - Overall 4 rows by 5 columns. (ignoring merged cells, it has 12 rows). (This is for example purposes as any table I might have will be N number of months within each phase).
ScreenHunter_03 Dec. 20 11.03.jpg

Column One "Phase" is in Excel Column A and Column Two "% Per..." is in B, Ect.

The rows titeld Design Phase, Construction Phase, and Post Occupnacy Phase, are merged cells if you can not tell from the picture.

What I am looking for is a macro that will look at a cell (this cell will be the answer to the question "How many months make up the phase.") and based on that cell, add rows within the table within each phase. So for example, "How many months make up the design phase" in one cell and the answer is (3), then the table has (3) rows within the design phase. If the user inputs (4) - then I would like to see the table ADD a row within Column "Month" and Column "Scheduled Invoice Amount". So the macro needs to look at how many are currently within the table. So if the user inputs (2), then one row will then need to be deleted from the current amount.
The remaining columns should be left alone (not look any differnt except obviously be taller in height) as those are merged cells.

This process needs to occur within the other two phases: construction phase and Post Occupancy phase.

The above pictured table is only an example.
Any intial starting table might have N number of months within each phase. The resulting table (from the macro) would need to be based upon the user's inputed data.

Is this do-able?

Thanks so much for taking the time to read my post and offer any suggestions.

Perhaps that I need to monitor the row count of each phase by using something similar to =IF(COUNT(NamedRange)='user input value,"insert rows by macro to match user input", "delete rows by macro to match user input")



So with that:

• I would need a macro to insert rows.
• A macro to delete rows.
• an event macro to run when an if statment is true / false.

Thoughts??????

Hey thanks for looking at this and taking your time to construct an answer. Unfortunately, due to the nature of how this file is going to be used and where its going to be used....it needs to stay in the same layout and format as shown in the the picture.

The "scheduled invoice amount" column is calculated off of how many months are within each phase. We have a set amount to be invoiced in each phase, so depending on how many months are to be invoiced (user inputed value) determines how much to invoice.

I have attached a sample table:
SampleWithTable.xlsm

Just noticed my formulas in column F are incorrect. Corrected version attached. SampleWithTable_updated.xlsm