Hi all

Obviously I am new to VBA code

I am getting this data from VBA code

Total MONTH TYPE D E F G
-================================================== =
1 0 Air Cooled 1 0 0 0
0 32 Column 16 11 5 0
2 0 Fire 0 1 0 1
489 0 Pipe 94 123 143 129
169 0 Pressure 16 51 52 50
126 0 Shell 53 33 33 7
17 0 Storage 3 11 2 1
836 0 Total 183 230 235 188

For the next Column I need to apply this Formula
=(10*D8+7*E8+4*F8+1*G8)/(D8+E8+F8+G8)

Now the no: of rows cld change.
I plan to do this, After I print all the data, I will fire a function
that look at D,E,F,G and do the calculations
Can I continue that to the bottom rows?

Thanx for ur help