Skip to content

Instantly share code, notes, and snippets.

@anchoo2kewl

anchoo2kewl/copy.vba

Created April 27, 2015 22:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anchoo2kewl/788ae8ee5c30d6813bf8 to your computer and use it in GitHub Desktop.
Save anchoo2kewl/788ae8ee5c30d6813bf8 to your computer and use it in GitHub Desktop.
Download ZIP
Copying values when IDs match
Raw
copy.vba
Private Sub Migrate()
For i = 3 To 26
For j = 3 To 62
If Sheets("final").Cells(j, 1) = Cells(i, 1).Value Or Sheets("final").Cells(j, 1) = Cells(i, 2).Value Or Sheets("final").Cells(j, 1) = Cells(i, 3).Value Then
Sheets("final").Cells(j, 7) = Cells(i, 4).Value
Sheets("final").Cells(j, 8) = Cells(i, 5).Value
End If
Next j
Next i
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment