Concatenate an entire row with another row - and place in another row

[jpcsolutions]

I have rows of data, A through G.

I need to concatenate rows F and G and place the result into row A.

This is what I'm currently using, but I'm having trouble getting it to run the macro down through all the cells in the rows, until there is no more data.

Please Login or Register  to view this content.

Any thoughts?

- Jared

[JieJenn]

Give this a try

Please Login or Register  to view this content.

[jpcsolutions]

Added to your rep. Thanks for your help!