Excel formula help

[Jamoulton87]

I have this paper I would like to input into a excel sheet so when someone add the number to the "pcs ran" it automatically completes the rest.
"Ind 1 X 2" would be pcs ran time 2 added to the current number in the line above it. How can I do this?

<a href="https://ibb.co/m654yA"><img src="https://preview.ibb.co/bwWzWV/20181028-101717.jpg" alt="20181028-101717" border="0"></a>

 

[shg]

	A​	B​	C​	D​	E​	F​	G​	H​	I​
1​			2​	4​	3​	2​	1​	1​
2​	Date​	Qty​	IND 1 X 2​	IND 2 X 4​	IND 3 X 3​	IND 4 x 2​	IND 5 x 1​	IND 6 X 1​	​
3​	10-16-18​	33​	3822​	6148​	14131​	14366​	7319​	7693​
4​	10-17-18​	30​	3882​	6268​	14221​	14426​	7349​	7723​	C4: =C3 + $B4 * C$1
5​	10-17-18​	38​	3958​	6420​	14335​	14502​	7387​	7761​
6​	10-17-18​	50​	4058​	6620​	14485​	14602​	7437​	7811​

 

[Jamoulton87]

Thanks... Is there a way I can program the columns to automatically do the formulas or do I have to manually enter the formula for each cell?

 

[shg]

There's only one formula, copied right and down.