VB code to find Blank in cell and copy row to another sheet

[rizmomin]

Hello:

Please refer to attached file.
I have data as shown in Sheet1
I need VB Code to perform following task.

In Column A, there are some cells which are blank.
So whenever there is blank cells in column A, I need that row and row before the blank to be copied to Sheet2
I have manually created this in Sheet2.

Let me know if you have any questions.
Thanks.

Riz

[Bo_Ry]

Please try

Please Login or Register  to view this content.

[rizmomin]

Hello Bo_Ry

Thanks a lot for quick help.
Would you please help modify the code so that in Sheet2, the blank cell in column A is filled with the row just before that.
So basically in Sheet, copying A2 to A3, A4 to A5 and so on

Really appreciate/

Thanks a lot

Riz

[Bo_Ry]

Try

Please Login or Register  to view this content.

[rizmomin]

Hello Bo_Ry

Thanks a lot, it works

Riz