Hey,
i'm trying to make a table that looks like this:
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
from this kind of data:
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
It's easy to set the formula in the left row with "$" to easily autofill to the right. Currently in the formula I have for example cell $C$12 that when going one cell down need to convert to $D$12.. I would be grateful for suggestions on possible changes to formula or a macro to be able to do this. I tried using macro with "Application.ConvertFormula" but i was able only to change every "$" in the cell but in this case it would need to be only specific ones.
i'm trying to make a table that looks like this:
B | C | D | E | F | G | |
---|---|---|---|---|---|---|
17 | 0 | 5 | 10 | 15 | 20 | |
18 | 0 | 0 | 3 | 3 | 9.5 | 7.1 |
19 | 5 | 3 | 0 | 0 | 11 | 9.4 |
20 | 10 | 3 | 0 | 0 | 11 | 9.4 |
21 | 15 | 9.5 | 11 | 11 | 0 | 5.7 |
22 | 20 | 7.1 | 9.4 | 9.4 | 5.7 | 0 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Data
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>
from this kind of data:
B | C | D | E | F | G | |
---|---|---|---|---|---|---|
10 | tacts | 0 | 5 | 10 | 15 | 20 |
11 | criterium | |||||
12 | a1 | 1 | 1 | 1 | 1 | 1 |
13 | a2 | 1 | 1 | 1 | 2 | 4 |
14 | a3 | 4 | 1 | 1 | 7 | 9 |
15 | a4 | 1 | 1 | 1 | 10 | 5 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Data
It's easy to set the formula in the left row with "$" to easily autofill to the right. Currently in the formula I have for example cell $C$12 that when going one cell down need to convert to $D$12.. I would be grateful for suggestions on possible changes to formula or a macro to be able to do this. I tried using macro with "Application.ConvertFormula" but i was able only to change every "$" in the cell but in this case it would need to be only specific ones.