Hi
I am a newbie to macros and i want to use macro to copy and paste the table data
Please look into the below tables and you will have a clear picture of what kind of result i am looking for
Input
<colgroup><col style="width:48pt" width="64" span="13"> </colgroup><tbody>
</tbody>
Output
<colgroup><col style="width:48pt" width="64" span="5"> </colgroup><tbody>
</tbody>Thanks in advance
I am a newbie to macros and i want to use macro to copy and paste the table data
Please look into the below tables and you will have a clear picture of what kind of result i am looking for
Input
User | O | D | M | T | O | D | M | T | O | D | M | T |
A | 101 | 106 | 1 | 1 | 106 | 201 | 2 | 2 | 201 | 101 | 1 | 1 |
B | 201 | 203 | 2 | 2 | 203 | 106 | 1 | 1 |
<colgroup><col style="width:48pt" width="64" span="13"> </colgroup><tbody>
</tbody>
Output
O | D | M | T | |
A | 101 | 106 | 1 | 1 |
106 | 201 | 2 | 2 | |
201 | 101 | 1 | 1 | |
B | 201 | 203 | 2 | 2 |
203 | 106 | 1 | 1 | |
<colgroup><col style="width:48pt" width="64" span="5"> </colgroup><tbody>
</tbody>