Hi all,
I have the following scenario at hand: In one worksheet I have an overview of items (1 row per item), with several columns of specifications per item (columns A through J). In column K, I have an operator I add manually, with two possible options "Yes" or "No". First row of data is row 2. Based on these two options I have a list of tasks that need to be completed, 15 tasks if the option is "Yes", 7 tasks if the option is "No".
Now I want to have a wholistic tracker in a new worksheet, which gives me all tasks needed for each item, with each task having its own row. The data should start in row 20.
Is this possible?
Thank you so much for your help!
Overview of items:
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Desired Tracker:
<colgroup><col span="11"><col><col></colgroup><tbody>
</tbody>
List of tasks:
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>
I have the following scenario at hand: In one worksheet I have an overview of items (1 row per item), with several columns of specifications per item (columns A through J). In column K, I have an operator I add manually, with two possible options "Yes" or "No". First row of data is row 2. Based on these two options I have a list of tasks that need to be completed, 15 tasks if the option is "Yes", 7 tasks if the option is "No".
Now I want to have a wholistic tracker in a new worksheet, which gives me all tasks needed for each item, with each task having its own row. The data should start in row 20.
Is this possible?
Thank you so much for your help!
Overview of items:
item | header 1 | header 2 | header 3 | header 4 | header 5 | header 6 | header 7 | header 8 | header 9 | option |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes |
item 2 | item 2 - spec 1 | item 2 - spec 2 | item 2 - spec 3 | item 2 - spec 4 | item 2 - spec 5 | item 2 - spec 6 | item 2 - spec 7 | item 2 - spec 8 | item 2 - spec 9 | No |
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Desired Tracker:
item | header 1 | header 2 | header 3 | header 4 | header 5 | header 6 | header 7 | header 8 | header 9 | option | task | |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes | Yes - task 1 | task 1 |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes | Yes - task 2 | task 2 |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes | Yes - task 3 | task 3 |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes | Yes - task 4 | task 4 |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes | Yes - task 5 | task 5 |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes | Yes - task 6 | task 6 |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes | Yes - task 7 | task 7 |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes | Yes - task 8 | task 8 |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes | Yes - task 9 | task 9 |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes | Yes - task 10 | task 10 |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes | Yes - task 11 | task 11 |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes | Yes - task 12 | task 12 |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes | Yes - task 13 | task 13 |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes | Yes - task 14 | task 14 |
item 1 | item 1 - spec 1 | item 1 - spec 2 | item 1 - spec 3 | item 1 - spec 4 | item 1 - spec 5 | item 1 - spec 6 | item 1 - spec 7 | item 1 - spec 8 | item 1 - spec 9 | Yes | Yes - task 15 | task 15 |
item 2 | item 2 - spec 1 | item 2 - spec 2 | item 2 - spec 3 | item 2 - spec 4 | item 2 - spec 5 | item 2 - spec 6 | item 2 - spec 7 | item 2 - spec 8 | item 2 - spec 9 | No | No - task 1 | task 1 |
item 2 | item 2 - spec 1 | item 2 - spec 2 | item 2 - spec 3 | item 2 - spec 4 | item 2 - spec 5 | item 2 - spec 6 | item 2 - spec 7 | item 2 - spec 8 | item 2 - spec 9 | No | No - task 2 | task 2 |
item 2 | item 2 - spec 1 | item 2 - spec 2 | item 2 - spec 3 | item 2 - spec 4 | item 2 - spec 5 | item 2 - spec 6 | item 2 - spec 7 | item 2 - spec 8 | item 2 - spec 9 | No | No - task 3 | task 3 |
item 2 | item 2 - spec 1 | item 2 - spec 2 | item 2 - spec 3 | item 2 - spec 4 | item 2 - spec 5 | item 2 - spec 6 | item 2 - spec 7 | item 2 - spec 8 | item 2 - spec 9 | No | No - task 4 | task 4 |
item 2 | item 2 - spec 1 | item 2 - spec 2 | item 2 - spec 3 | item 2 - spec 4 | item 2 - spec 5 | item 2 - spec 6 | item 2 - spec 7 | item 2 - spec 8 | item 2 - spec 9 | No | No - task 5 | task 5 |
item 2 | item 2 - spec 1 | item 2 - spec 2 | item 2 - spec 3 | item 2 - spec 4 | item 2 - spec 5 | item 2 - spec 6 | item 2 - spec 7 | item 2 - spec 8 | item 2 - spec 9 | No | No - task 6 | task 6 |
item 2 | item 2 - spec 1 | item 2 - spec 2 | item 2 - spec 3 | item 2 - spec 4 | item 2 - spec 5 | item 2 - spec 6 | item 2 - spec 7 | item 2 - spec 8 | item 2 - spec 9 | No | No - task 7 | task 7 |
<colgroup><col span="11"><col><col></colgroup><tbody>
</tbody>
List of tasks:
Option | Task |
Yes | task 1 |
Yes | task 2 |
Yes | task 3 |
Yes | task 4 |
Yes | task 5 |
Yes | task 6 |
Yes | task 7 |
Yes | task 8 |
Yes | task 9 |
Yes | task 10 |
Yes | task 11 |
Yes | task 12 |
Yes | task 13 |
Yes | task 14 |
Yes | task 15 |
No | task 1 |
No | task 2 |
No | task 3 |
No | task 4 |
No | task 5 |
No | task 6 |
No | task 7 |
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>