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

[Dilusha]

I have Following Master Table in Sheet1

[TABLE="class: cms_table_grid, width: 100"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[TD]Column E[/TD]
[TD]Column F[/TD]
[TD]Column G[/TD]
[/TR]
[TR]
[TD]Row1[/TD]
[TD]Cus_Code[/TD]
[TD]Inv_Date[/TD]
[TD]Inv_No[/TD]
[TD]Cus_Name[/TD]
[TD]Value[/TD]
[TD]VAT[/TD]
[/TR]
[TR]
[TD]Row2[/TD]
[TD]BBE[/TD]
[TD]18/07/2018[/TD]
[TD]SV4525[/TD]
[TD]A CO .LTD[/TD]
[TD]11899[/TD]
[TD]1785[/TD]
[/TR]
[TR]
[TD]Row3[/TD]
[TD]BBE[/TD]
[TD]20/07/2018[/TD]
[TD]SV4531[/TD]
[TD]A CO.LTD[/TD]
[TD]16667[/TD]
[TD]2500[/TD]
[/TR]
[TR]
[TD]Row4[/TD]
[TD]DSL[/TD]
[TD]31/07/2018[/TD]
[TD]SV4825[/TD]
[TD]DS LTD[/TD]
[TD]23261[/TD]
[TD]3489[/TD]
[/TR]
[TR]
[TD]Row5[/TD]
[TD]EVE[/TD]
[TD]01/07/2018[/TD]
[TD]SV4401[/TD]
[TD]E CO LTD[/TD]
[TD]7142[/TD]
[TD]1071[/TD]
[/TR]
[TR]
[TD]Row6[/TD]
[TD]EVE[/TD]
[TD]15/07/2018[/TD]
[TD]SV4513[/TD]
[TD]E CO LTD[/TD]
[TD]6987[/TD]
[TD]1048[/TD]
[/TR]
[TR]
[TD]Row7[/TD]
[TD]EVE[/TD]
[TD]21/07/2018[/TD]
[TD]SV4625[/TD]
[TD]E CO LTD[/TD]
[TD]3107[/TD]
[TD]466[/TD]
[/TR]
</tbody>[/TABLE]



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 ...................
[TABLE="class: cms_table_grid, width: 100"]
<tbody>[TR]
[TD]Serial No[/TD]
[TD]Inv_No[/TD]
[TD]Inv_Date[/TD]
[TD]Value[/TD]
[TD]vat[/TD]
[TD]voucher No[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



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.