Copying concatenating two rows in a macro

Alright, this question sounds simple at first, but nothing I've tried all day will do what I want it to.
I've attached my sample workbook with my macro so you can see my data

My workbook has two sheets. sheet1 and sheet2.

My macro needs to compare column A from sheet2 with column A in sheet1. Anytime there is a match I want to take the row that matched on sheet2 and paste it on the end of the corresponding row in sheet1.

I believe I have the nested for loops that are doing the comparison working properly, what I can't figure out is how to copy the row from sheet2 and paste it at the end of the corresponding row in sheet1. It needs to be dynamic, the row lengths may differ and ideally I would like to exclude the cell in column A, sheet2 when I paste that row into sheet1, however this isn't required.

Any help is appreciated.

Here is the macro, it is also included in the attachment.

Please Login or Register  to view this content.

Hi

See how this goes.

Please Login or Register  to view this content.

rylo

You guys are amazing. Both versions work flawlessly.

Thanks a bunch!

Hi

You have got it on the sizing. However, if there is some consistent way of determining just what you want changed, where it starts / ends, or how many columns are to be included, it may be possible to have those items adjusted dynamically.

Is that sort of detail able to be determined from your data?

rylo

Well there will always be 2 sheets. The columns will always start in column A on both sheets. The final column on both sheets will be variable.

In every case, all columns in sheet2 will be appended to the columns in sheet 1 (for the particular row that is getting pasted from sheet 2 to sheet 1)

So really just accounting for more or less columns in either sheet. I figured it would be similar to the way that the macro already adjusts for more or less rows when determining the data set.

Hi

Have a go at adjusting the code and see if you can make it work. Come back if you have problems.

Have fun...

rylo