Repeat Insert Row And Formula For Selected Cells

I am in the process of developing a budget template for next year and here is what I want to accomplish through Macro to avoid the tedious mannual manipulation process (hope that's achievable). BTW, I am only an entry-level Macro user who has no background in coding.

I have attached an Excel sample but let me explain:

In each of the expenses tabs (1, 2, and so on (only 1, 2 given in the sample)), I want to be able to select a range of the data cells (A19:Q34 in "Expense 1" and A10:Q28 in "Expense 2") and run this Macro so that:

1. 10 blank rows be inserted between selected data rows

2. A sum created for each month from the four rows below) with different color

3. A Year to Date Actual and To Year End Forecast created based on the VLOOKUP of the "P&L" matching the account code by month

4. Finally grouping of the first 9 rows.

the above is what I have manually created for the first account code in the "expense 1" tab. I have 7-8 expenses groups and about 200 account codes. So mannually creating the above for each expense groups is not that terrible if this will make life easier for Macro.

I would think this is a very typical Macro issue but can't really come up with anything.

The other issue I ran into the VLOOKUP for the YTD Actual and TYE Forecast. It is to look up accont code in the "P&L" tab and match the #s. But the column numbers in the VLOOKUP do not change automatically when I copy across. Thus I have to change mannually, which is really a pain in the butt. I also know I can't copy down because that will change the account code that I want it to match. Because to be able to copy the VLOOKUP formula across the same account code, I need to use the $ to fix the account code. But to copy down I think I need that to be without the $ sign. Any solution on that?

• Insert Range-named Row At User-selected Row
• F4 Does Not Repeat Insert Rows Or Columns
• Insert Row At Active Cell With Formula From Fixed Row
• Insert A Row And Copy The Value Or Formula Of The Upper Row
• Insert Rows & Repeat Values Based On Corresponding Cell Value
• Copy Cells In Selected Row To New Sheet
• Insert Formula Every X Row
• Insert Row Below Cells Containing X
• Insert A Row And Add A Formula
• Command Button: Copy Row Selected On Sheet2 Into Cells On Sheet 1
• Copy Selected Rows & Insert As Many Times As Rows Selected
• Apply Formula To Selected Cells Via Macro
• Formula References Not Updating On Row Insert/Delete
• SumIf Formula: Add New Data With An Insert At Row 13
• Insert Cell To Columns Having X Blank Cells In Row
• Repeat Title Row Every Page
• Row Repeat In Bottom While Printing
• Look Up Dont Repeat Row Of Data
• Using VBA To Insert Formula Into Cells ...
• Insert Formula In Empty Cells
• Repeat Row Based On Text Criteria
• Insert Rows And Copy Formula Cells
• Changing Row Collor Based On One Cell - Repeat
• Repeat Row Labels On All Lines Of A Pivot Table
• Copy All The Rows Until Row 37 And Move It One Row Up After The Selected Row Is Deleted
• Copy & Repeat Single Row Information To Many Rows
• Copy Each Row Of Table & Repeat Rows X Times
• Not Repeat The Same Formula In Each Cell, Over And Over Again
• Repeat VBA Formula
• Repeat A Formula Automatically Every Seven Columns
• Insert Two Columns For Selected Rows
• To Write A Macro That Will Insert A Formula Directly Into The Cells In Column M Of My Worksheet
• Repeat Vlookup And Find Or Search Formula
• Pulling Multiple Matches (formula Repeat?)
• Repeat Data As User Fills In Other Cells
• Repeat The Following Rows And Formula With Column A Starting At 9150
• Adding Rows With Control Number That Only Repeat 3 Times: Formula
• Identify Button (shape) Row To Insert Row And Delete Row
• Stop Formula Column Reference Changing On Insert But Not Row Reference
• Insert Excel Formula Using VBA......MATCH Function Is What I Want To Insert
• Insert Row On Sheet & Move Active Cell Row To It
• Insert Row Syntax - Resize Row VBA Error
• Insert Row- Macro Pasting Format And Formulas Under Last Row
• Auto Insert A Row With Info Populated From The Row Above
• Insert A Blank New Row If Check The Different Content In The Next Row
• Duplicating Insert Row And Delete Row On Another Sheet
• With A Formula That Will Alert Me If There Are Any Blanck Or 0 Value Cells In A Row
• Formula To Find A Name And Average Other Cells In The Same Row
• Automatically Insert Row When Row Value In Column Changes
• Insert Row And Copy Cell From New Row