I have this table that has a computation, is it possible to automatically compute inside a vba without the formula based? I am a little slow in for loop or iteration. Can someone help me so that I can follow on how to compute the following items. I want to automate the computation instead of having a formula. Automate the computation for column A-C by row.
Compute first column A up to down then column B and so on..
OUTPUT
A B C
1 5 19 45
2 10 21 0
3 0 32 17
DATA
A 1 5
B 2 21
B 3 32
C 1 45
A 2 10
C 3 17
B 1 19
Bookmarks