gsgurpreetsingh501
New Member
- Joined
- Jan 7, 2016
- Messages
- 12
Problem is to copy the column data from one sheet to other sheet (after last row) on matching of the column heading.
In the below sheet, Name is matching in both the sheets. So matching on "Name" basis, the entire "Name" column in Sheet 1 has to be copied to the end of Sheet2 Name column.
Sheet1:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Sheet2:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Result of Sheet2:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
In the below sheet, Name is matching in both the sheets. So matching on "Name" basis, the entire "Name" column in Sheet 1 has to be copied to the end of Sheet2 Name column.
Sheet1:
S.No | Date | weight | Name |
1 | 4/3/2016 | 70 | John |
2 | 4/3/2016 | 75 | Andrew |
3 | 4/3/2016 | 67 | Gill |
4 | 4/4/2016 | 80 | Macmillan |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Sheet2:
S.No | Name | Days |
1 | Brian | 2 |
2 | Neil | 5 |
3 | Kim | 10 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Result of Sheet2:
S.No | Name | Days | Duration (Days) |
1 | Brian | 2 | 2 |
2 | Neil | 5 | 5 |
3 | Kim | 10 | 10 |
John | |||
Andrew | |||
Gill | |||
Macmillan |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>