need a macro to fill data from Master table to individual sheets.

[Dilusha]

I have Following Master Table in Sheet1

Column A	Column B	Column C	Column D	Column E	Column F	Column G
Row1	Cus_Code	Inv_Date	Inv_No	Cus_Name	Value	VAT
Row2	BBE	18/07/2018	SV4525	A CO .LTD	11899	1785
Row3	BBE	20/07/2018	SV4531	A CO.LTD	16667	2500
Row4	DSL	31/07/2018	SV4825	DS LTD	23261	3489
Row5	EVE	01/07/2018	SV4401	E CO LTD	7142	1071
Row6	EVE	15/07/2018	SV4513	E CO LTD	6987	1048
Row7	EVE	21/07/2018	SV4625	E CO LTD	3107	466

<tbody>
</tbody>

Column B is sorted & I have created sheets for each customer by the name of Cus_Code in same work book.

In sheet2 , I have following table.

Name Of Customer ...................

Serial No	Inv_No	Inv_Date	Value	vat	voucher No
1
2
3
4

<tbody>
</tbody>

Signature ........... Date................

I want to fill above table & as per the Master table (Rows should be dynamics) & copy to the relevant sheet created with the name of Cus_Code.

Name of Customer should be filled .Column F ( voucher No) & "Signature ..... / Date ......Should be kept blank .

I use excel 2007

 

[Macropod]

This is a duplicate of: https://www.mrexcel.com/forum/excel...ter-table-individual-sheet-dynamic-table.html
Kindly read Mr Excel's policy in Rule 12 against asking questions about the same topic in multiple threads: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html
Thread closed. You may continue the discussion in your other thread.