Hi,
I have a table with 9 columns and 2 row(including one header), where the data(a,b,c) changes based on a number(x). a,b, c are lookups/formulas based on a larger table.
I need to record the changes made when I increment that number(x). I tried to map it in the table below.
I have never used VBA. If anyone could give me some guidance, it would be great.
Thanks,
Amir
<tbody>
</tbody>
I have a table with 9 columns and 2 row(including one header), where the data(a,b,c) changes based on a number(x). a,b, c are lookups/formulas based on a larger table.
I need to record the changes made when I increment that number(x). I tried to map it in the table below.
I have never used VBA. If anyone could give me some guidance, it would be great.
Thanks,
Amir
initial table | h1 | h2 | h3 | |
x | a | b | c | |
VBA generated result table | h1 | h2 | h3 | |
x | a | b | c | |
x+1 | a1 | b1 | c1 | |
x+2 | a2 | b2 | c2 | |
x+n | an | bn | cn |
<tbody>
</tbody>