Pretty Vacant
New Member
- Joined
- May 18, 2015
- Messages
- 31
Morning all,
I have a spreadsheet with a list of tasks and their costs. I would like to be able to manually put in a quantity against some of the tasks and populate a summary sheet on a separate worksheet.
So,
I have a list of tasks as belowup to about 650 rows)
<tbody>
</tbody><colgroup><col><col><col span="2"></colgroup>
and I'd like to end up with something like below on a separate worksheet:
<tbody>
</tbody><colgroup><col><col><col span="3"></colgroup>
Can anybody assist me with this? Any help is gratefully received.
P
I have a spreadsheet with a list of tasks and their costs. I would like to be able to manually put in a quantity against some of the tasks and populate a summary sheet on a separate worksheet.
So,
I have a list of tasks as belowup to about 650 rows)
code | Task | Amount | Cost |
1B.001.01 | Task A | 1 | 150 |
1B.001.02 | Task B | 2 | 200 |
1B.001.03 | Task C | 1 | 100 |
1B.001.04 | Task D | 50 | |
1B.001.05 | Task E | 1 | 25 |
1B.001.06 | Task F | 1 | 35 |
<tbody>
</tbody><colgroup><col><col><col span="2"></colgroup>
and I'd like to end up with something like below on a separate worksheet:
code | Task | Amount | Cost | Amount |
1B.001.01 | Task A | 1 | 150 | 150 |
1B.001.02 | Task B | 2 | 200 | 400 |
1B.001.03 | Task C | 1 | 100 | 100 |
1B.001.05 | Task E | 1 | 25 | 25 |
1B.001.06 | Task F | 1 | 35 | 35 |
<tbody>
</tbody><colgroup><col><col><col span="3"></colgroup>
Can anybody assist me with this? Any help is gratefully received.
P