Macro to cut two rows and insert them in different sheet in order of date

[kosherboy]

Hello.
I'm looking for a macro that would cut two preselected rows out of the first sheet in this attachment INSERT ROW.xlsm i.e. rows 9 & 10 and insert it in the 2nd sheet in order of column "B" (the date).
The reason why I am not recording a macro using the sorting tool is because the sorting function would get rid of the blank row between each row with data. (I need this blank row to enter notes)
Any help would be greatly appreciated.

Thank you.

[Kaper]

Hi,

It is not clearly stated, how the rows to be moved are to be determined.
I assumed that the cursor is in the first row of the two - (i.e. row 9).
So having a cursor in row 9 of sheet 1 run macro test:

Please Login or Register  to view this content.

If other method is to be used - just determine the first row and call move_two with the appropriate row number as argument.

[kosherboy]

Hi, thanks for your reply.
I will look at it over the weekend.
Thanks again.