Hello everyone,
I really thought I could do it but after a morning having fun I decided to ask for help.
I have a data tab with some characteristics in the range B32:C43 (on the B column is the characteristic and on C is a "yes or no"). I want to copy the cell B content when the cell C value is "yes" to the sheet 5 starting from B17 onwards.
There is a catch, on row 40 there is a number (that goes from 1 to infinite). In the middle of the copy, I want to create as many lines as specified in C40 and fill them with "Trial X" (where X is the number).
It's something like this
And this should generate in the sheet 5 something like this:
Can somebody help me?
I really thought I could do it but after a morning having fun I decided to ask for help.
I have a data tab with some characteristics in the range B32:C43 (on the B column is the characteristic and on C is a "yes or no"). I want to copy the cell B content when the cell C value is "yes" to the sheet 5 starting from B17 onwards.
There is a catch, on row 40 there is a number (that goes from 1 to infinite). In the middle of the copy, I want to create as many lines as specified in C40 and fill them with "Trial X" (where X is the number).
It's something like this
|
| Column C | ||
Row 32 | Moisture Exposition | Y | ||
Row 33 | Biological | N | ||
Row 34 | Screening | Y | ||
Row 35 | Gama X | N | ||
Row 36 | Gama Y | N | ||
Row 37 | Gama Z | N | ||
Row 38 | Gama T | N | ||
Row 39 | Alfa 32 | Y | ||
Row 40 | Number of trials | 5 | ||
Row 41 | Overcount | Y | ||
Row 42 | Final testing | N |
And this should generate in the sheet 5 something like this:
Column A | Column B |
Row 17 | Moisture Exposition |
Row 18 | Screening |
Row 19 | Alfa 32 |
Row 20 | Trial 1 |
Row 21 | Trial 2 |
Row 22 | Trial 3 |
Row 23 | Trial 4 |
Row 24 | Trial 5 |
Row 25 | Overcount |
Can somebody help me?