bug in vba - move data from sheet1 to sheet 2

[jackf-nc]

I am attempting to move data from sheet1 to sheet2 based on date. While it appears to be working, I get correct lines of out put, the rows are all scambled. Its ike they are randomly placed.

Here is code I am using:

Please Login or Register  to view this content.

I have attached sheet with data from sheet 1, and example of sheet 2 and a CORRECTED sheet 2 of whats its supposed to look like, I also included a test page showing what my current results show.

Any assistance would be a big help. More importantly tell me what the heck did I miss and why random rows.

[ikboy]

Try this:

Please Login or Register  to view this content.

[djbomaha]

This post had already been answered by the time I posted mine.