Hi I want to assign range of cells into array, then search first column ( columna "A"), and copy to another sheet lines which has in first column "a". Generally I know how works "for... next", but have no idea how to do it in array and copy.
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
| a | 1 | A |
| b | 2 | B |
| b | 3 | B |
| c | 4 | C |
| d | 5 | D |
| a | 6 | A |
| c | 7 | C |
| d | 8 | D |
| a | 9 | A |
| c | 10 | C |
| b | 11 | B |
| b | 12 | B |
| c | 13 | C |
| d | 14 | D |
| a | 15 | A |
| c | 16 | C |
| c | 17 | C |
| d | 18 | D |
| a | 19 | A |
| a | 20 | A |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
