austinandrei
Board Regular
- Joined
- Jun 7, 2014
- Messages
- 117
Hi,
I have a data in Column A as below:
<colgroup><col></colgroup><tbody>
</tbody>If I filter the Serial Number as "899559" then I get 3 items which I would like to copy in a sheet.
Problem is that it is a fixed template and I need to insert it in between.
Thus, since there are 3 items, I would need to insert 3 entire blank rows.
Can you help me to know the macro codes in counting of the number of rows filtered and the macro code to insert that number of rows?
Thanks.
austin
I have a data in Column A as below:
Serial Number |
899816 |
899688 |
899559 |
899559 |
899559 |
895704 |
<colgroup><col></colgroup><tbody>
</tbody>
Problem is that it is a fixed template and I need to insert it in between.
Thus, since there are 3 items, I would need to insert 3 entire blank rows.
Can you help me to know the macro codes in counting of the number of rows filtered and the macro code to insert that number of rows?
Thanks.
austin