Populated the cell value with related row's text with matched named worksheet

[dipak182]

HI,

I have a excel workbook. which have a master data sheet or table as drawn by you.
[TABLE="class: cms_table, width: 660"]
<tbody>[TR]
[TD][/TD]
[TD] A B C D E F G H I J
[TABLE="class: cms_table_grid, width: 500, align: center"]
<tbody>[TR]
[TD]Sl.No[/TD]
[TD]CUSTOMER[/TD]
[TD]ORDER[/TD]
[TD]DARCL[/TD]
[TD]MMT[/TD]
[TD]SSL[/TD]
[TD]TOLL[/TD]
[TD]RITC[/TD]
[TD]VGH[/TD]
[TD]GRT[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]M/S ABG[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]M/S FGT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]M/S UIW[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]M/S KRT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]M/S FHJ[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

.
The above sheet is master sheet. I have also worksheets which named are matching with column head from "DARCL", "MMT", SSL"......till "GRT" (No "order" named worksheet is there). So I want to feed data or value as total order in "ORDER" column, (it is not necessary to put the value in each row) and the total value or number is distributed by me in particular column or colums. After data feeding I have required a command button or any button that can copy or show the reference row (customer name) with its cell value in the matched column head worksheet. As example: total order is 200 put in "ORDER" column in row 3, and 200 is distributed as by myself 100 in column "E" (MMT) and 100 in column "H" (RITC) and so on...after this feeding, I click the button and the data will show or copy as table M/S UIW : 100 in "MMT" worksheet and M/S UIW: 100 in "RITC" worksheet.
As example:

(Each worksheet contains this format)

[TABLE="class: cms_table, width: 739"]
<tbody>[TR]
[TD="colspan: 4"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Customer's Name[/TD]
[TD]Qty ( In Bags)[/TD]
[TD]Nos. Vehicles[/TD]
[TD]Customer's Name[/TD]
[TD]Qty ( In Bags)[/TD]
[TD]Nos. Vehicles[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]0 6[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]0 7[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]0 8[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD]0 9[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]0 10[/TD]
[TD][/TD]
[TD][/TD]
[TD]0
[/TD]
[/TR]
</tbody>[/TABLE]



After click command button on the master sheet the related customer name and the value will be populated in respective matched column head with worksheet. If there is no cell value in master sheet the below mentioned cell are hides.

Thanks.[/TD]
[TD]









[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]