I have one big dataset, only one column but thousands of rows.

How do I (with macro?) make a criteria something like this:

1. check the value of the row 1, if value is > -0.5 then copy the value to the new dataset.

2. After this check the value of the next row with the same criteria. And also copy the value to the next row of the same dataset.

3. Do this as long as the value stays within the criteria.

4. If value is -0.5 then create a new dataset as mentioned in point 1.

Thanks in advance…

Kari