Based on inserting a new row in first sheet - in another sheet find the last row and create new set of rows with predefined formatting and formulas

[hananak]

Dear All,

In my excel workbook, I have two sheets.

1) Summary
2) Schedule

In summary sheet whenever I insert one row. It should automatically create in the schedule sheet 13 (Including the Total) rows with predefined formatting and formulas but remove the constants.

I have uploaded the mini sheets.

First Row in the summary sheet and 13 rows in the Schedule sheet already created manually by me. From here I am looking for a VBA code (Macro), that will do this task whenever any one insert row in summary sheet.

Your help would be really appreciated.

Many Thanks.

Sample Register.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2
3	SERVICE/STAFF NAME	ORGANISATION	DEPT	SPECIALTY	BUDGET CODE	NOMINAL CODE	ANNUAL EXPENSE	MONTHLY EXPENSE	YTD INVOICE	AMOUNT TO ACCRUE	ACCRUALS PERIOD	Purpose	NARRATIVE
4	Rubino	Dunhill College London	#REF!	#REF!	303405	849200	16,000	1,333.33	2,527.16	-	0	Salary Recharge	#REF!
5
Summary

Sample Register.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1		SCHEDULE
2
3
4		Month	3	M03	31/03/2022
5
6		DEPT	COMPANY	MAIN CODE	NOMINAL CODE	STAFF NAME	MONTHS	PERIOD	INV NO	INV AMOUNT £	ACCRUALS	ACCRUALS PERIOD	COMMENTS
7	1		Dunhill College London			Rubino	M01	Apr-21	12345	1,263.58	Check
8	2		Dunhill College London			Rubino	M02	May-21	6789	1,263.58	Check
9	3		Dunhill College London			Rubino	M03	Jun-21
10	4		Dunhill College London			Rubino	M04	Jul-21
11	5		Dunhill College London			Rubino	M05	Aug-21
12	6		Dunhill College London			Rubino	M06	Sep-21
13	7		Dunhill College London			Rubino	M07	Oct-21
14	8		Dunhill College London			Rubino	M08	Nov-21
15	9		Dunhill College London			Rubino	M09	Dec-21
16	10		Dunhill College London			Rubino	M10	Jan-22
17	11		Dunhill College London			Rubino	M11	Feb-22
18	12		Dunhill College London			Rubino	M12	Mar-22
19	Rubino					Total				2,527.16	0.00
Schedule

 

[hananak]

Can anyone confirm whether it is possible please?

 

[hananak]

Anyone Please help or at least let me know if this is something possible?