Macro that merges matching data from two sheets and pastes to a new sheet (in line)

[njmiller31]

Hey All,

I'm surprised I couldn't find this exact problem in another thread. Anyway, I have 3 sheets:
RA1
RA2
Paired RA

I'm working on a macro that matches data from the first two sheets and lines it up in the third. I need it to:
-Compare file IDs (columns B) from RA1 and RA2 sheets.
-Move matching (omit non-matching) file IDs and their corresponding data (columns A, C, D) to the Paired RA sheet.
-Line-up the matching file IDs and other data on the same row.

See attached example
Paired Data Example.xlsx

The code I have so far seems to match them well enough, but it doesn't line the matches up.

Please Login or Register  to view this content.

I'm relatively new to macros. Any idea what I'm doing wrong?

THANKS!

[njmiller31]

Oops! Pasted the wrong code. The only difference between the code I posted and the one I'm using is the name of the third sheet. It's "Paired RA" not "Combined RA."

[jindon]

Try the attached

[njmiller31]

That worked perfectly! Thank you so much for your help!

[njmiller31]

I thought I'd come back and thank you again, Jindon. That code is flawless. It works really well. I appreciate your fast response.

[jindon]

I thought I'd come back and thank you again, Jindon. That code is flawless. It works really well. I appreciate your fast response.

Glad that you like it and thanks for the feedback.

[dinker454]

If I wanted to do this same thing but with more than one sheet and also have the data that do not match copied over to a new line, how would I do that? Is there a way?