Copy formula to next row

[JerryKaminsky]

I have a 3 formulas in column E-G that produce data from columns A-D. I would like to hide columns E-G. My problem is I cannot get the formula to repeat itself when data is entered on the next row. There is a macro that creates a text file for each row of data based on the results in columns E-G. Below are the formulas of each column and the data array that adds additional data to the file.

= CHAR(34) & A2 & CHAR(34) & VLOOKUP(C2,FileDefs,2,FALSE)
=VLOOKUP(C2,FileDefs,3,FALSE) & CHAR(34) & D2 & CHAR(34) & VLOOKUP(C2,FileDefs,4,FALSE)
=A2 & "." & VLOOKUP(C2,FileDefs,5,FALSE) & RIGHT(B2,1)

Entity Type	Header Suffix	Record Prefix - Client Code	Record Suffix	File Extension
990​	,,,,,"M"	"RETURN OPTIONS","0","0","0","CLIENT CODE",	,"O"	EX
1040​	,,,,,,,,,"M"	"BASIC OPTIONS","0","0","0","CLIENT CODE",	,"O"	AX
1041​	,,,,,"M"	"GENERAL OPTIONS","0","0","0","02-CLIENT CODE",	,"O"	FX
1065​	,,,,,"M"	"RETURN OPTIONS","0","0","0","CLIENT CODE",	,"O"	PX
1120​	,,,,,"M"	"GENERAL INFORMATION","0","0","0","CLIENT CODE",	,"O"	CX