Vijaya Kanthi
New Member
- Joined
- Jul 27, 2018
- Messages
- 14
Hello,
I have a report which is generated in grouping type.... data will be something like this :
Original Source:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[/TR]
[TR]
[TD]Code
[/TD]
[TD]Date
[/TD]
[TD]Size
[/TD]
[TD]Sample
[/TD]
[TD]Pass
[/TD]
[TD]Fail
[/TD]
[TD]%
[/TD]
[/TR]
[TR]
[TD]Code1
[/TD]
[TD]01.08.2018
[/TD]
[TD]10
[/TD]
[TD]5
[/TD]
[TD]5
[/TD]
[TD]5
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]02.08.2018
[/TD]
[TD]10
[/TD]
[TD]5
[/TD]
[TD]4
[/TD]
[TD]1
[/TD]
[TD]80
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]03.08.2018
[/TD]
[TD]10
[/TD]
[TD]5
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]60
[/TD]
[/TR]
[TR]
[TD]Code2
[/TD]
[TD]01.08.2018
[/TD]
[TD]20
[/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]02.08.2018
[/TD]
[TD]20
[/TD]
[TD]10
[/TD]
[TD]9
[/TD]
[TD]1
[/TD]
[TD]90
[/TD]
[/TR]
[TR]
[TD]Code 3
[/TD]
[TD]01.078.2018
[/TD]
[TD]30
[/TD]
[TD]15
[/TD]
[TD]10
[/TD]
[TD]5
[/TD]
[TD]66.6
[/TD]
[/TR]
</tbody>[/TABLE]
The report is grouped at Code1,code 2, code 3
Now I want to create a Macro which can re-create the Macro in the below format....
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]01.08.2018
[/TD]
[TD]02.08.2018
[/TD]
[TD]03.08.2018
[/TD]
[TD]04.08.2018
[/TD]
[TD]05.08.2018
[/TD]
[/TR]
[TR]
[TD]jj
[/TD]
[TD]kk
[/TD]
[TD]Code 1
[/TD]
[TD]100
[/TD]
[TD]80
[/TD]
[TD]60
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ss
[/TD]
[TD]yy
[/TD]
[TD]Code 2
[/TD]
[TD]100
[/TD]
[TD]90
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ll
[/TD]
[TD]mm
[/TD]
[TD]Code 3
[/TD]
[TD]66.6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]rr
[/TD]
[TD]ee
[/TD]
[TD]Code 4
[/TD]
[TD]100
[/TD]
[TD]98
[/TD]
[TD]90
[/TD]
[TD]96
[/TD]
[TD]95
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
There are 151 codes and the dates has to change according to the Week... If the macro can ask for which week /days it has to take from the orginial source... that would help a lot
kindly advice
Help is much appreciated
Regards,
K
I have a report which is generated in grouping type.... data will be something like this :
Original Source:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[/TR]
[TR]
[TD]Code
[/TD]
[TD]Date
[/TD]
[TD]Size
[/TD]
[TD]Sample
[/TD]
[TD]Pass
[/TD]
[TD]Fail
[/TD]
[TD]%
[/TD]
[/TR]
[TR]
[TD]Code1
[/TD]
[TD]01.08.2018
[/TD]
[TD]10
[/TD]
[TD]5
[/TD]
[TD]5
[/TD]
[TD]5
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]02.08.2018
[/TD]
[TD]10
[/TD]
[TD]5
[/TD]
[TD]4
[/TD]
[TD]1
[/TD]
[TD]80
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]03.08.2018
[/TD]
[TD]10
[/TD]
[TD]5
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]60
[/TD]
[/TR]
[TR]
[TD]Code2
[/TD]
[TD]01.08.2018
[/TD]
[TD]20
[/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]02.08.2018
[/TD]
[TD]20
[/TD]
[TD]10
[/TD]
[TD]9
[/TD]
[TD]1
[/TD]
[TD]90
[/TD]
[/TR]
[TR]
[TD]Code 3
[/TD]
[TD]01.078.2018
[/TD]
[TD]30
[/TD]
[TD]15
[/TD]
[TD]10
[/TD]
[TD]5
[/TD]
[TD]66.6
[/TD]
[/TR]
</tbody>[/TABLE]
The report is grouped at Code1,code 2, code 3
Now I want to create a Macro which can re-create the Macro in the below format....
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]01.08.2018
[/TD]
[TD]02.08.2018
[/TD]
[TD]03.08.2018
[/TD]
[TD]04.08.2018
[/TD]
[TD]05.08.2018
[/TD]
[/TR]
[TR]
[TD]jj
[/TD]
[TD]kk
[/TD]
[TD]Code 1
[/TD]
[TD]100
[/TD]
[TD]80
[/TD]
[TD]60
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ss
[/TD]
[TD]yy
[/TD]
[TD]Code 2
[/TD]
[TD]100
[/TD]
[TD]90
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ll
[/TD]
[TD]mm
[/TD]
[TD]Code 3
[/TD]
[TD]66.6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]rr
[/TD]
[TD]ee
[/TD]
[TD]Code 4
[/TD]
[TD]100
[/TD]
[TD]98
[/TD]
[TD]90
[/TD]
[TD]96
[/TD]
[TD]95
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
There are 151 codes and the dates has to change according to the Week... If the macro can ask for which week /days it has to take from the orginial source... that would help a lot
kindly advice
Help is much appreciated
Regards,
K