dancingdata
New Member
- Joined
- Aug 18, 2017
- Messages
- 6
Hello,,
I am trying to create an outline numbering list from a data table which look like below:
<colgroup><col><col></colgroup><tbody>
</tbody>Result to be as follow:
4 1.1 1.1.1
4 1.1 1.1.2
4 1.1 1.1.3
4 1.1 1.1.4
3 1.2 1.2.1
3 1.2 1.2.2
3 1.2 1.2.3..etc
Can you help with a VBA code that can automate this process? Basically I need the VBA to insert new cells based on the number of criteria then generate the numbering for each numbering category.
Appreciate your support.
I am trying to create an outline numbering list from a data table which look like below:
# of Criteria | Numbering Category |
4 | 1.1 |
3 | 1.2 |
4 | 1.3 |
4 | 2.1 |
<colgroup><col><col></colgroup><tbody>
</tbody>
4 1.1 1.1.1
4 1.1 1.1.2
4 1.1 1.1.3
4 1.1 1.1.4
3 1.2 1.2.1
3 1.2 1.2.2
3 1.2 1.2.3..etc
Can you help with a VBA code that can automate this process? Basically I need the VBA to insert new cells based on the number of criteria then generate the numbering for each numbering category.
Appreciate your support.