hi,
can help provide macro code to copy rows and paste in the above blank rows?

\1


the in-between blank rows varies, sometimes it's 3 rows blank, 1 row blank, 10 rows blank or no blank. i need to copy the row and "fill up" the blank rows, but not overwriting the row if there's data on Column A.

not only copy column A-D, but the whole row.
the screeny shows copied rows in red for illustration purposes only, the macro need not work in red.

your help appreciated.

thanks,