Hello guys,
I would like to run a macro that allows me to group some data that is scattered into tabular form. In particular, the information to be retrieved is "anticipated" by a number label contained in the cell immediately to the left of the relevant data to be retrieved. In addition, these labels are contained in definied columns.
For example:
<tbody>
</tbody>
<tbody>
</tbody>
In this case, the macro should search all the value reported between the labels from 1 to 5 and return these values in a different sheet with the relevant labels.
This would really help me a lot because I have more than 500 labels (and as much information) that I should convert into the table format.
Many thanks!
I would like to run a macro that allows me to group some data that is scattered into tabular form. In particular, the information to be retrieved is "anticipated" by a number label contained in the cell immediately to the left of the relevant data to be retrieved. In addition, these labels are contained in definied columns.
For example:
A | B | C | D | E |
1 | 1.000 | |||
2 | 2.000 | |||
3 | 3.000 | |||
4 | 4.000 | 5 | 10.000 |
<tbody>
</tbody>
A | B |
1 | 1.000 |
2 | 2.000 |
3 | 3.000 |
4 | 4.000 |
5 | 10.000 |
<tbody>
</tbody>
In this case, the macro should search all the value reported between the labels from 1 to 5 and return these values in a different sheet with the relevant labels.
This would really help me a lot because I have more than 500 labels (and as much information) that I should convert into the table format.
Many thanks!
Last edited: