That is a good question. I am hoping that the macro works its way down
the page so that if there happen to be two blank rows (in column A) in
a row that after the macro is run the first one will fill and then when
it gets to the next row the row above it will already be filled so that
there is data in the cells to copy and paste. I hope this makes sense.
Also, the data starts from the first row in the sheet so there will
never be a case where there are blank rows on the top of the sheet
however when it gets to the bottom of the data set (approx 690 rows) I
would like it to end the macro so that it doesn't keep doing this all
the way down to row 65,536

Thanks in advance!

Brian