Excel Table Automatically Expanding

[clappl001]

I have a table that I want to have a total row while also adding new rows automatically when a row of data is completed. I am having trouble because I have formulas and data validation that need to be maintained if a row is added.

Currently I have removed the total row and when i enter data into the cell A4 and press enter it will try and create a new row for the table but the user has to know at least one of the options that are available in column As drop down menu otherwise it causes a data validation issue. I would like to avoid that and have it make a new row when the final cell of the previous row is completed.

Here is the table.

OrderSheetTest.xlsx
	A	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
1										Glide / MX2 Bottom Rail Details				Made 2 Measure or Lineals Only
2	Category	Product Description (Select)	Image	Frame Colour Options (Hidden)	Parts Colour Options (Hidden)	Frame Colour	Frame Colour ABV (Hidden)	Parts Colour	Parts Colour ABV (Hidden)	Colour	Tape	Glide Drain Holes	Glide Screw Holes	Width or Length	Height	Install Type	Handing	SKU Generator #1 (Hidden)	SKU Generator #2 (Hidden)	SKU	Material	Allotment	Quantity	Unit $	Total $
3	MX2StandardSizePC	MX2, Pleated Retractable Screen. 1100x2400 (43 5/16 x 94 1/2), Powder Coat		MX2FrameColoursPC	MX2PartsColours	Black	BK	Black	BK									MX2-1100x2400	MX2-1100x2400-BKBK	MX2-1100x2400-BKBK	UPVC, PET, Alum	1 set	1	$ 155.96	$ 155.96
4
Order Sheet

Cell Formulas
Range	Formula
C3	C3	=IFERROR(VLOOKUP(B3,ITEMS!B3:D223,3,FALSE),"")
D3	D3	=IFERROR(VLOOKUP(B3,ITEMS!B3:J223,9,0),"")
E3	E3	=IFERROR(VLOOKUP(B3,ITEMS!B3:K223,10,0),"")
G3	G3	=IFERROR(VLOOKUP(F3,Colours!B2:C10,2,0),"")
I3	I3	=IFERROR(VLOOKUP(H3,Colours!B2:C10,2,0),"")
R3	R3	=IFERROR(VLOOKUP(B3,ITEMS!B3:C223,2,0),"")
S3	S3	=IF(OR(A3="MX2StandardSizePC",A3="MX2UKStandardSizePC",A3="MX2StandardSizeAZ",A3="MX2UKStandardSizeAZ"),R3& "-" &G3&I3,R3)
T3	T3	=S3
U3	U3	=IFERROR(VLOOKUP(B3,ITEMS!B3:E223,4,FALSE),"")
V3	V3	=IFERROR(VLOOKUP(B3,ITEMS!B3:F223,5,FALSE),"")
X3	X3	=IFERROR(VLOOKUP(B3,ITEMS!B3:G223,6,FALSE),"")
Y3	Y3	=IFERROR(W3*X3,"")

Named Ranges
Name	Refers To	Cells
AluminumExtrusionsAZ	=ITEMS!$B$92:$B$109	C3:E3, R3, U3:V3, X3
AluminumExtrusionsPC	=ITEMS!$B$73:$B$90	C3:E3, R3, U3:V3, X3
FMAParts	=ITEMS!$B$42:$B$44	C3:E3, R3, U3:V3, X3
GeneralParts	=ITEMS!$B$52	C3:E3, R3, U3:V3, X3
Magnet	=ITEMS!$B$29	C3:E3, R3, U3:V3, X3
MGParts	=ITEMS!$B$162:$B$181	C3:E3, R3, U3:V3, X3
MX2Parts	=ITEMS!$B$3:$B$25	C3:E3, R3, U3:V3, X3
MX2ReplacementCartridges	=ITEMS!$B$145:$B$160	C3:E3, R3, U3:V3, X3
MX2StandardSizeAZ	=ITEMS!$B$128:$B$143	C3:E3, R3, U3:V3, X3
MX2StandardSizePC	=ITEMS!$B$111:$B$126	C3:E3, R3, U3:V3, X3
MX2UKReplacementCartridges	=ITEMS!$B$219:$B$223	C3:E3, R3, U3:V3, X3
MX2UKStandardSizeAZ	=ITEMS!$B$201:$B$217	C3:E3, R3, U3:V3, X3
MX2UKStandardSizePC	=ITEMS!$B$183:$B$199	C3:E3, R3, U3:V3, X3
PVCExtrusions	=ITEMS!$B$31:$B$40	C3:E3, R3, U3:V3, X3
Screws	=ITEMS!$B$54:$B$71	C3:E3, R3, U3:V3, X3
Tape	=ITEMS!$B$46:$B$49	C3:E3, R3, U3:V3, X3
TensionWire	=ITEMS!$B$27	C3:E3, R3, U3:V3, X3

Cells with Data Validation
Cell	Allow	Criteria
A3	List	=Categories!$A$1:$A$21
B3	List	=INDIRECT(A3)
F3	List	=INDIRECT(D3)
H3	List	=INDIRECT(E3)