Loop to copy rows from two worksheets until reaching empty row

Hi,

I've been searching around for a way to do this, which I would think should be pretty easy to do, but I haven't found something that works yet.
I have worksheets X, Y and Z. X and Y contain the same amount of rows with corresponding data, and Z only has data in the first three rows. I want a macro that can copy the data from the corresponding rows in X and Y and paste them pairwise in Z, as shown below:

Z Row 1 data

Z Row 2 data

Z Row 3 data

(empty row)

X Row 2

Y Row 2

(empty row)

X Row 3

Y Row 3

(empty row)

X Row 4

Y Row 4

... and so on. The loop should end at the first empty row in X or Y (it will be the same for both).
I really appreciate if someone could help me with this, and hope I've made it clear what I'm looking for.

Thanks Mike! As you said, that was pretty close. I had to make a few tweaks to make it work with my data.

Please Login or Register  to view this content.