Unexperienced VBA user, trying to create a Repo Schedule for use at my office

[belowram]

Trying to create an excel workbook with 1 input sheet, and 1 schedule sheet.

Input sheet:

I would like the info i input into the white cells be moved to corresponding cells in the Schedule sheet.

Cell C3 from the input sheet moved to cell Q4 in the schedule sheet.
Cell C7 from the input sheet -> cell C4 in the schedule sheet.
Cell C9 from the input sheet -> cell D4 in the schedule sheet.
Cell C11 from the input sheet -> cell F4 in the schedule sheet.
Cell C13 from the input sheet -> cell G4 in the schedule sheet.
Cell E3 from the input sheet ->cell B4 in the schedule sheet.
Cell F5 from the input sheet -> cell M4 in the schedule sheet.
Cell F7 from the input sheet -> cell N4 in the schedule sheet.
Cell F9 from the input sheet -> cell L4 in the schedule sheet.
Cell F11 from the input sheet -> cell U4 in the schedule sheet.
Cell F13 from the input sheet-> cell V4 in the schedule sheet.

However, the problem I am facing with my VBA code is that when the data is moved to the schedule sheet, all the values in row 4 are being moved down a row to row 5.
But as in the mini sheet below, I have equations linked to the cells that are not mentioned above, so I would be best if only the cells mentioned above are moved down a row in the Schdule sheet.
Would this be possible at all?
If not, i have no idea what would be the best method to create such a system.
Any help would be much appreciated.
Thanks guys



schedule sheet:

Repo Schedule_test1.xlsx.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
2	#	Terms								Collateral						Counterparty				FX				P&L
3	Serial No.	Initiation Date	Maturity	Days	RP Rate	Haircut(%)	Repo Amount	Open/Term	Days Remaining	Collateral Pool	ISIN	Collateral Amount	Collateral Rate	Price	Face Value	Counterparty	Depository	EC/CS	Account No.	FX	FX Rate (Book)	FX Rate(Spot)	Face Value(FX)	FX P&L	Interest Paid	Interest Received	Total P&L(USD)	Total P&L(FX)
4
5	#REF!	7/4/2024	8/4/2024	31	5.50%	5%	38,000,000.00	Term	59	BBG		40,000,000.00	5.80%	bbg	#VALUE!
6
7
schedule

Cell Formulas
Range	Formula
H5:H7	H5	=IF((M5*(1-G5))>0,(M5*(1-G5)),"")
I5:I7	I5	=IF((D5=""),"",IF(D5=0,"Open","Term"))
J5:J7	J5	=IF((D5-TODAY())>0, (D5-TODAY()),"")
P5	P5	=M5*O5
B5:B6	B5	=IF(C5>0,("REPO"&MOD(YEAR(C5),100)&TEXT(MONTH(C5),"00")&TEXT(DAY(C5),"00")&TEXT((#REF!),"000")),"")
B7	B7	=IF(C7>0,("REPO"&MOD(YEAR(C7),100)&TEXT(MONTH(C7),"00")&TEXT(DAY(C7),"00")&TEXT((AE5),"000")),"")
E5:E7	E5	=IF((D5-C5)>0,(D5-C5),"")

 

[arun_eagertolearn]

Hi

Can you pls share the VBA code being used

thanks