match data 2 sheets. if match, then copy data from one sheet to another

Hi Guys,

I’ve got an issue with VBA. I’ve got 2 sheets. In every sheet there’s a column with ID’s (sheet 1 is column B and in sheet 2 it’s column A). These ID’s needs to be matched. If there’s a match, then should column C until H from sheet 2 copied to sheet 1 in cell G.

I hope that you can help me. If you need an example, just say so : )

Thanks

Originally Posted by OllieB

flunzy,

If you can post a copy of the workbook, I will write the solution

Hi OllieB,

As requested the 2 excelsheet. one is before the macro and the other after the macro.

Thanks for the support

Originally Posted by OllieB

Code added to the attached workbook

Thanks OllieB, but it's almost correct. I miss the e-mailadress after macro has been used. It seems that the e-mailadres isn't being copied : (

A different approach

A different approach.

Originally Posted by AB33

A different approach.

I've tried your code but it's only running the three first rows. when I expand the sheet, it doesn't work : (

Originally Posted by OllieB

New version, you asked for the paste to start in column G so I did not copy the e-mail address into column F

for so far your code workes : ) I still have to test it out with a larger sheet : D

The code should work in any range as long as you do not have complete blank row or column in either sheet, but can easily change if you wish

Amended code