I have 5 columns and many rows of numbers. I want to select a row of numbers that contains, for example, the number 5 and move those numbers to a new sheet. How can I do this?
Example:
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
The bolded Rows above, I'd want on a new sheet because those sequence of numbers contain a 5.
Thanks.
Example:
1 | 2 | 3 | 4 | 41 |
1 | 2 | 3 | 4 | 42 |
1 | 2 | 3 | 4 | 43 |
1 | 2 | 3 | 5 | 6 |
1 | 2 | 3 | 5 | 7 |
1 | 2 | 3 | 5 | 8 |
1 | 2 | 3 | 5 | 9 |
1 | 2 | 3 | 5 | 10 |
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
The bolded Rows above, I'd want on a new sheet because those sequence of numbers contain a 5.
Thanks.