Ankitsahgal
New Member
- Joined
- Dec 19, 2015
- Messages
- 11
Hi All,
I have in sheet1 , the following data
<colgroup><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
I want to summarize the above information in Sheet2 in the following format:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The actual data has a lot more information (Overtime1, overtime2,etc) and also a lot more employees.
I have tried to use Cell and Indirect function for reference but I am unable to get the desired result.
Can someone please help
Thank you
Ankit
I have in sheet1 , the following data
Employee Number | Name | Basic Salary | Overtime | Lieu | Bonus |
3 | Smith, John | £200 | £10 | £0 | £0 |
64 | Porter, Helen | £210 | £0 | £35 | £0 |
38 | Rayne, Alex | £300 | £0 | £0 | £50 |
<colgroup><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
I want to summarize the above information in Sheet2 in the following format:
GL Code | Description | Amount |
2000 | Smith, John Basic Salary | £200 |
3000 | Smith, John Overtime | £10 |
2000 | Smith, John Lieu | £0 |
3500 | Smith, John Bonus | £0 |
2000 | Porter, Helen Basic Salary | £210 |
3000 | Porter, Helen Overtime | £0 |
2000 | Porter, Helen Lieu | £35 |
3500 | Porter, Helen Bonus | £0 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The actual data has a lot more information (Overtime1, overtime2,etc) and also a lot more employees.
I have tried to use Cell and Indirect function for reference but I am unable to get the desired result.
Can someone please help
Thank you
Ankit