acidburn786
New Member
- Joined
- Aug 15, 2008
- Messages
- 48
I am Trying to Report on some information based on 2 selections.
Selection 1 = Company
Selection 2 = Process
Each process consist of a number of Activities (1 up to 25) Rows
Data is in sheet1
Lookup in sheet2
So when I select, the Company and a process
Activities should be displayed under each other.
The time it takes for each activity will depend on which Company I selected
Sheet1
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:128px;"><col style="width:204px;"><col style="width:194px;"><col style="width:133px;"><col style="width:202px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
So in the Example above. A21:B25 should be formulae that pul data in
Selection 1 = Company
Selection 2 = Process
Each process consist of a number of Activities (1 up to 25) Rows
Data is in sheet1
Lookup in sheet2
So when I select, the Company and a process
Activities should be displayed under each other.
The time it takes for each activity will depend on which Company I selected
Sheet1
* | A | B | C | D | E |
1 | sheet1 | * | * | * | * |
2 | Process | SLA | Company A | Company B | Company C |
3 | Process 1 | Activity 1 | 25 | * | 25 |
4 | Process 1 | Activity 2 | None | n/a | N/a |
5 | Process 1 | Activity 3 | Prior to payment of commission | * | Prior to payment of Commission |
6 | Process 1 | Activity 4 | N/a | n/a | N/a |
7 | Process 1 | Activity 5 | N/a | * | N/a |
8 | Process 2 | Activity 1 | N/a | * | 5 |
9 | Process 2 | Activity 2 | N/a | 5 | N/a |
10 | Process 3 | Activity 1 | 35 | * | * |
11 | Process 4 | Activity 1 | 45 | * | 3 |
12 | Process 4 | Activity 2 | * | 5 | 3 |
13 | Process 4 | Activity 3 | * | * | * |
14 | * | * | * | * | * |
15 | * | * | * | * | * |
16 | sheet2 | * | * | * | * |
17 | * | * | * | * | * |
18 | Process selected: | Process 1 | Company selected: | Company A | * |
19 | * | * | * | * | * |
20 | Activities | Period | * | * | * |
21 | Activity 1 | 25 | * | * | * |
22 | Activity 2 | None | * | * | * |
23 | Activity 3 | Prior to payment of commission | * | * | * |
24 | Activity 4 | N/a | * | * | * |
25 | Activity 5 | N/a | * | * | * |
26 | * | * | * | * | * |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:128px;"><col style="width:204px;"><col style="width:194px;"><col style="width:133px;"><col style="width:202px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
So in the Example above. A21:B25 should be formulae that pul data in
Last edited: