m_vishal_c
Board Regular
- Joined
- Dec 7, 2016
- Messages
- 209
- Office Version
- 365
- 2016
- Platform
- Windows
hi I have 2 sheets in same workbook. i need vba code which copy data from 1 file to another file as raw for example
I have these data in Sheet 1
A B
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Sheet 2
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
when i press button on sheet 1 then data will be copy to sheet 2 in next raw
please guide me
heaps thanks in advance
thanks
I have these data in Sheet 1
A B
Name | 1 |
Address | 2 |
City | 3 |
Company | 4 |
Salary | 5 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Sheet 2
Name | Address | City | Company | Salary | |
1 | 2 | 3 | 4 | 5 |
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
when i press button on sheet 1 then data will be copy to sheet 2 in next raw
please guide me
heaps thanks in advance
thanks