Add data from a given row to the rest of the rows in the worksheet and append the results at the end...

[hiskn]

I have a set of data in let us say row 1 (D1 to H1) that needs to be added with the data in the remaining rows (say D2 to H20),I need the results to be in the rows D21 to H39). Essentially I would like to have a code that does the below:

D21 = D$1 + D2
E21 = E$1 + E2
...
...
H21 = H$1 + H2

D22 = D$1 + D3
E22 = E$1 + E3
....
H39 = H$1 + H20

I appreciate your help to have this in a vba code.

skn

 

[hiskn]

I am a newbie.. Any hints..thanks..