justanothernametaken
New Member
- Joined
- Aug 27, 2014
- Messages
- 3
Hi could use some help. What i have is this below - What i want to do is a VBA code that says if A2 sheet1 can be found in column A of sheet2 replace B2 sheet 1 with what is in B in sheet2. Example is if A2 (John) appears in Column A in Sheet 2, replace B2 sheet1 with whats showing in the following cell in B in this case George. Is this possible? Thanks oh great masters of excel :D
<tbody>
</tbody>
Column A Sheet1 | Column B Sheet1 | Column A Sheet2 | Column B Sheet2 | |
Name | Name | Name | Name | |
John | Brian | John | George | |
Casey | Lloyd | Casey | Robert | |
Lakisha | Derek | Lakisha | Sydney | |
Jason | Paul | Jason | Ryan | |
Casey | Brian | Casey | Jeremy | |
Derek | John | Derek | Gina | |
Brian | Paul | Brian | Betty |
<tbody>
</tbody>