Populate the cell value and rows text in another sheet which match the column head.

[dipak182]

I have a excel workbook. which have a master data sheet or table as drawn.

Please Login or Register  to view this content.

. 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 layout of others worksheets.(attach pic)

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.

Please help me.

Thanks

master sheet.jpg
others worksheets.jpg

[protonLeah]

Should we post a picture of the solution?

[dipak182]

Sorry Sir,

Please find the attachment.

Thanks

[dipak182]

Is there any one who can help me?????

[dipak182]

I am still waiting for your solution.