Copy data from a sheet source to several created new sheets

[luis_marques]

Hi,

I made a drawing to explain my need.

I have a sheet in woorkbook that is a source where each row is a order. New orders are always in the new rows that are being created and going down.

I need to copy a model sheet in the wookbok for each order created. Then fill data from the source in each new row to the same field in the each new order created.

Please see the schema attached for a better understanding.

 

[Belleke]

Post an example of your workbook so that I can see the fields you are using to create an order.

 

[luis_marques]

I posted a sample of sheet. Thanks for your assessment.

 

[luis_marques]

Post an example of your workbook so that I can see the fields you are using to create an order.

Hi, is that ok, or you need anything more detailed?

 

[bosco_yip]

Hi, is that ok, or you need anything more detailed?

Hi,

1] Check attached file whether it is what you needed.

2] Select order no. from D3 dropdown list, the following red text cells will return the information in accordingly.

Regards
Bosco