Hi everyone,
[FONT=arial, sans-serif]Is it possible to create a macro for below.
[/FONT]
<colgroup><col><col></colgroup><tbody>
</tbody>Output Need;
<colgroup><col><col><col><col><col><col><col span="31"></colgroup><tbody>
</tbody>
[FONT=arial, sans-serif]Is it possible to create a macro for below.
[/FONT]
Note:
<tbody> </tbody> | ||||||||||||||||||||||||||||||||||||||||||||||
Output Needed ; I want the Amount on date wise after fullfilling the combination and valid date range. | ||||||||||||||||||||||||||||||||||||||||||||||
Input ;
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col></colgroup><tbody>
</tbody>
A | B | C | D | E | CONCATENATE | 01-05-2016 | 02-05-2016 | 03-05-2016 | 04-05-2016 | 05-05-2016 | 06-05-2016 | 07-05-2016 | 08-05-2016 | 09-05-2016 | 10-05-2016 | 11-05-2016 | 12-05-2016 | 13-05-2016 | 14-05-2016 | 15-05-2016 | 16-05-2016 | 17-05-2016 | 18-05-2016 | 19-05-2016 | 20-05-2016 | 21-05-2016 | 22-05-2016 | 23-05-2016 | 24-05-2016 | 25-05-2016 | 26-05-2016 | 27-05-2016 | 28-05-2016 | 29-05-2016 | 30-05-2016 | 31-05-2016 |
ABO1 | KGW | F97 | C534 | 23 | ABO1KGWF97C53423 | 20,400.00 | 20,400.00 | 20,400.00 | 20,400.00 | 20,400.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 | 21,150.00 |
ABO1 | KGW | F80 | C535 | 23 | ABO1KGWF80C53523 | |||||||||||||||||||||||||||||||
ABO1 | KGW | F97 | C540 | 23 | ABO1KGWF97C54023 |
<colgroup><col><col><col><col><col><col><col span="31"></colgroup><tbody>
</tbody>