Here is my problem: I have two data sheets, each with two columns.
Data Sheet 1
| Column A | Column B |
|---|---|
| [email protected] | John Doe |
| [email protected] | Jane Doe |
Data Sheet 2
| Column A | Column B |
|---|---|
| [email protected] | Doe, John 123456 |
| [email protected] | Doe, Jane 654321 |
How do I setup an excel macro so that it takes the data from Column A, finds the matching data in Column A of Data Sheet 2, then copies the data in Data Sheet 1 Row 1, Column B and pastes it in the corresponding row in Data Sheet 2, but in Column C.
Hope I illustrated this problem clearly. Thank you so much for your help!
Resulting Sheet
| Column A | Column B | Column C |
|---|---|---|
| [email protected] | Doe, John 123456 | John Doe |
| [email protected] | Doe, Jane 654321 | Jane Doe |
I have not tried anything yet.
New contributor
Isabelle Gan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.