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:
<tbody>
</tbody>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....
<tbody>
</tbody>
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:
| A | B | C | D | E | F | G |
| Code | Date | Size | Sample | Pass | Fail | % |
| Code1 | 01.08.2018 | 10 | 5 | 5 | 5 | 100 |
| 02.08.2018 | 10 | 5 | 4 | 1 | 80 | |
| 03.08.2018 | 10 | 5 | 3 | 2 | 60 | |
| Code2 | 01.08.2018 | 20 | 10 | 10 | 10 | 100 |
| 02.08.2018 | 20 | 10 | 9 | 1 | 90 | |
| Code 3 | 01.078.2018 | 30 | 15 | 10 | 5 | 66.6 |
<tbody>
</tbody>
Now I want to create a Macro which can re-create the Macro in the below format....
| A | B | C | D | E | F | G | H |
| 01.08.2018 | 02.08.2018 | 03.08.2018 | 04.08.2018 | 05.08.2018 | |||
| jj | kk | Code 1 | 100 | 80 | 60 | ||
| ss | yy | Code 2 | 100 | 90 | |||
| ll | mm | Code 3 | 66.6 | ||||
| rr | ee | Code 4 | 100 | 98 | 90 | 96 | 95 |
<tbody>
</tbody>
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
