Is there a way to generate lines, in another tab and fill them with data?

[BBelmans]

[FONT=&quot]I have a line of data in one tab, I like to copy it to another tab, in the last cell there is a code in the same row like so: H789, that’s a reference the other sheet, where there is a number from 1….9999, that’s the amount of copies I have to make.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]The sheet I have the data is looks like this:[/FONT]

CODE	ROWS	SOURCES	POSITIONS
A123	4​	CN,CN,CN,FL	IN,OU,MA,BN
X456	2​	FL,FL	IN,OU
Y789	3​	CN,CN,CN	IN,OU,BN
H789	4​	CN,CN,CN, FL	IN,OU,MA,BN
IL12	2​	FL,FL	IN,OU
KFT5	3​	CN,CN,CN	IN,OU,BN
BNT5	4​	CN,CN,CN,CS	IN,OU,MA,BN

<tbody style="box-sizing: inherit; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;">
</tbody>

[FONT=&quot] [/FONT]
[FONT=&quot]In the copied rows there has to be put in the data from the sources and positions.[/FONT]

 

[DanteAmor]

I have a line of data in one tab, I like to copy it to another tab, in the last cell there is a code in the same row like so:


You can put how this information is on the sheet.
H789, that’s a reference the other sheet, where there is a number from 1….9999, that’s the amount of copies I have to make.

The sheet I have the data is looks like this:

CODE	ROWS	SOURCES	POSITIONS
A123	4​	CN,CN,CN,FL	IN,OU,MA,BN
X456	2​	FL,FL	IN,OU
Y789	3​	CN,CN,CN	IN,OU,BN
H789	4​	CN,CN,CN, FL	IN,OU,MA,BN
IL12	2​	FL,FL	IN,OU
KFT5	3​	CN,CN,CN	IN,OU,BN
BNT5	4​	CN,CN,CN,CS	IN,OU,MA,BN

<tbody>
</tbody>

You can also give an example of what the result of the copy would be like.
In the copied rows there has to be put in the data from the sources and positions.

I am waiting for your information