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]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][td="bgcolor:#C0C0C0"]

E​

[/td][td="bgcolor:#C0C0C0"]

F​

[/td][td="bgcolor:#C0C0C0"]

G​

[/td][td="bgcolor:#C0C0C0"]

H​

[/td][td="bgcolor:#C0C0C0"]

I​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td][/td][td][/td][td]

2​

[/td][td]

4​

[/td][td]

3​

[/td][td]

2​

[/td][td]

1​

[/td][td]

1​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td="bgcolor:#F3F3F3"]

Date​

[/td][td="bgcolor:#F3F3F3"]

Qty​

[/td][td="bgcolor:#F3F3F3"]

IND 1 X 2​

[/td][td="bgcolor:#F3F3F3"]

IND 2 X 4​

[/td][td="bgcolor:#F3F3F3"]

IND 3 X 3​

[/td][td="bgcolor:#F3F3F3"]

IND 4 x 2​

[/td][td="bgcolor:#F3F3F3"]

IND 5 x 1​

[/td][td="bgcolor:#F3F3F3"]

IND 6 X 1​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]

10-16-18​

[/td][td]

33​

[/td][td]

3822​

[/td][td]

6148​

[/td][td]

14131​

[/td][td]

14366​

[/td][td]

7319​

[/td][td]

7693​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]

10-17-18​

[/td][td]

30​

[/td][td="bgcolor:#CCFFCC"]

3882​

[/td][td="bgcolor:#CCFFCC"]

6268​

[/td][td="bgcolor:#CCFFCC"]

14221​

[/td][td="bgcolor:#CCFFCC"]

14426​

[/td][td="bgcolor:#CCFFCC"]

7349​

[/td][td="bgcolor:#CCFFCC"]

7723​

[/td][td="bgcolor:#CCFFCC"]C4: =C3 + $B4 * C$1[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]

10-17-18​

[/td][td]

38​

[/td][td="bgcolor:#CCFFCC"]

3958​

[/td][td="bgcolor:#CCFFCC"]

6420​

[/td][td="bgcolor:#CCFFCC"]

14335​

[/td][td="bgcolor:#CCFFCC"]

14502​

[/td][td="bgcolor:#CCFFCC"]

7387​

[/td][td="bgcolor:#CCFFCC"]

7761​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]

10-17-18​

[/td][td]

50​

[/td][td="bgcolor:#CCFFCC"]

4058​

[/td][td="bgcolor:#CCFFCC"]

6620​

[/td][td="bgcolor:#CCFFCC"]

14485​

[/td][td="bgcolor:#CCFFCC"]

14602​

[/td][td="bgcolor:#CCFFCC"]

7437​

[/td][td="bgcolor:#CCFFCC"]

7811​

[/td][td][/td][/tr]
[/table]

 

[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.