Cus_Code | Inv. No | Date | Rs |
CDD | V4525 | 21/8/2018 | 1525 |
CDD | V4531 | 5/8/2018 | 1522 |
CFF | V2547 | 11/8/2018 | 4522 |
GHB | V1478 | 25/5/2018 | 3256 |
GHB | V2358 | 31/8/2018 | 2563 |
<tbody>
</tbody>
I have above table in sheet1(start from A1) and I have inserted sheets by name of Cus_code in same work book.
The inserted sheets have same table (starting A1). I want a macro to transfer data from sheet1 to relevant sheets.
Eg.
No | Inv.No | Date | Rs |
1 | V1478 | 25/5/2018 | 3256 |
2 | V2358 | 31/8/2018 | 2563 |
<tbody>
</tbody>
This Table should be created in sheet GHB .
Table headings already created.
But Serial No (I.e 1,2,3) Should be generated automatically.
I Use excel 2007
pls help me .