Hello Everyone!
I got a question to split/copy specific rows of a list to a new sheet. I have try'd searching here on the forums but i coudnt find anything comming close to it.
In the sheet they will put an X in a cell with above the numbers 5, 6 or 7. Then the list needs to be copy'd to a new sheet by 5lines 6lines or 7 lines. Underneath i will try to explain it.
Sheet 1:
a b c d e f g h i j k
1 a 1 5 6 7
2 b 2 x
3 c 3
4 d 4
5 e 5
6 f 6
7 g 7
8 h 8
9 i 9
See that 5 is selected with the x.
sheet 2:
a b c d e f g h i j k l m n o p q
1 1 a 1 10 cd 111
2 b 2 de 123
3 c 3 kl 876
4 d 4 ij 487
5 e 5 ki 765
6
7 2 f 6 11 etc
8 g 7 etc
9 h 8
10 i 9
11 k 10
12
13 3 l 11
14 m12
15 n 13
16
This is how it should look like in the new sheet. But when the X is underneath the 6 the rows should be 6 long. I hope you understand what we want.
thx in advance!
Edit: THe picture i draw didnt look anything like we want i will upload a picture.
I got a question to split/copy specific rows of a list to a new sheet. I have try'd searching here on the forums but i coudnt find anything comming close to it.
In the sheet they will put an X in a cell with above the numbers 5, 6 or 7. Then the list needs to be copy'd to a new sheet by 5lines 6lines or 7 lines. Underneath i will try to explain it.
Sheet 1:
a b c d e f g h i j k
1 a 1 5 6 7
2 b 2 x
3 c 3
4 d 4
5 e 5
6 f 6
7 g 7
8 h 8
9 i 9
See that 5 is selected with the x.
sheet 2:
a b c d e f g h i j k l m n o p q
1 1 a 1 10 cd 111
2 b 2 de 123
3 c 3 kl 876
4 d 4 ij 487
5 e 5 ki 765
6
7 2 f 6 11 etc
8 g 7 etc
9 h 8
10 i 9
11 k 10
12
13 3 l 11
14 m12
15 n 13
16
This is how it should look like in the new sheet. But when the X is underneath the 6 the rows should be 6 long. I hope you understand what we want.
thx in advance!
Edit: THe picture i draw didnt look anything like we want i will upload a picture.
