VBA Compare Two Columns and Copy Matching Data

**hobbiton73** · 02-18-2014, 05:46 AM

Hi, I wonder whether somoene may be able to help me please.

I'm using the code below to compare columns on two sheets (1 column for each) and where there is a match, copy data from the 'Source' to 'Destination' sheet.

Please Login or Register  to view this content.

The code works fine, but I'd like to amend this, but I'm a little unsure about how to proceed.

The script currently compares column C on the 'Source' sheet with column D on the 'Destination' sheet and where a match is found copy column G from the 'Source' sheet and pastes this to column O on the 'Destination' sheet.

I'd still like to copy and paste the same columns, but I'd like to compare two columns from each sheet, so from the 'Source' sheet compare columns C and E to columns D and J on the 'Destination' sheet.

I just wondered whether someone could possibly look at this please and offer some guidance on how I may achieve this.

Many thanks and kind regards

**AB33** · 02-18-2014, 06:12 AM

Christ,
This is mick's code.
I do not have any data to test it on.

Please Login or Register  to view this content.

**hobbiton73** · 02-18-2014, 07:31 AM

Hi @AB33, thank you for taking the time to reply to my post.

As you say this was @MickG's code, with also your help at this link: http://www.excelforum.com/excel-prog...opy-cells.html,which created the script above. My apologies for not making reference to this in my original post and if this caused offence, it was certainly not my intention.

I've amended the code to included your revisions, and it works perfectly, thank you very much.

All the best and kind regards

Chris