Compare 2 columns on different sheets and move data when match

Ask a question AnnetteeBrown 1Posts Thursday April 20, 2017Registration date April 20, 2017 Last seen - Last answered on Apr 21, 2017 at 02:17 PM by ac3mark

I need to match 2 columns of data from 2 different worksheets and when they match, I need to move data from another column from one worksheet to the other.

Sheet 1
Name Address 1 Address 2
John 123 Main St Suite 4
John 567 Name Rd Suite 8
Mike 894 First St
Mike 100 Main St Suite 2

Sheet 2
Name Address 1 need to move address 2 here from Sheet 1 when Name and
Address 1 match

There can be one name with multiple addresses, so Column A will have duplicate names so vLookup cannot be used.

Thank you
plus moins
Try something like this:


Here is how it works.

The IF statement is standard, if (logic test, logic test is true, logic test is false). In the above example, we have dropped the False value of the logic test, as it is not mandatory. If the logic test is true, then the subroutine of moveit is fired. You will notice that we pass a variable to moveit. The routine of moveit takes the sheet2cell value and posts it onto your sheet that you want it moved to.

Let us know if this will work.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!