I have no clue how to making this formula work..

[TDNova]

Hello again!

I have a problem that i need help with, I got two numbers (1380,1381 "serie nr")
This is hard to explain (new),but i give it a go.

when there is more than one number "1380,1381" i want it to copy the whole row expect the first number and make a new row with all the same information. (this counts for all the Serie nr in the row).
but the problem is i already use formula to split up all the information from the first cell.

If I haven't explained it good enough i will reply.

First

HSET 24-30/2/118+84 (118-73)1380,1381

HSET

24-30/2/118+84

118-73

1380

1381

OUK 8-8 (309-28B)1374,1375

OUK

8-8

309-28B

1374

1375

HTK 14-30/120/2 (118-74)1388,1389

HTK

14-30/120/2

118-74

1388

1389

HTK

TOK 5-15/2 (118-67)1408,1409

TOK

5-15/2

118-67

1408

1409

118-65A

118-65A

<tbody>
</tbody>

HSET 24-30/2/118+84 (118-73)1380,1381

HSET

24-30/2/118+84

118-73

1380

OUK 8-8 (309-28B)1374,1375

OUK

8-8

309-28B

1374

HTK 14-30/120/2 (118-74)1388,1389

HTK

14-30/120/2

118-74

1388

1389

HTK

TOK 5-15/2 (118-67)1408,1409

TOK

5-15/2

118-67

1408

1409

118-65A

118-65A

<tbody>
</tbody>

HSET 24-30/2/118+84 (118-73)1380,1381

HSET

24-30/2/118+84

118-73

1381

OUK 8-8 (309-28B)1374,1375

OUK

8-8

309-28B

1375

HTK 14-30/120/2 (118-74)1388,1389

HTK

14-30/120/2

118-74

1388

1389

HTK

TOK 5-15/2 (118-67)1408,1409

TOK

5-15/2

118-67

1408

1409

118-65A

118-65A

<tbody>
</tbody>

 

[TDNova]

So to sum it up

1. checks the whole row if there is more than one Serie.nr.
2. When it find one or more, copy the row
3. Make a New row and paste inn the information without the first serie nr.

I just want all the serie nr. to have their own row and nothing else inn the row need to change.
Is it possible to do with Formula or do i need to go over to VBA?