Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. Dim i As Integer
  2. i = 1
  3. For i = 3 To 20
  4. If (Range("A" & i).Select = Range("D" & i).Select) Then
  5. Range("A" & i).Select
  6. Selection.Copy
  7. Range("G" & i).Select
  8. ActiveSheet.Paste
  9. Range("B" & i).Select
  10. Selection.Copy
  11. Range("H" & i).Select
  12. ActiveSheet.Paste
  13. End If
  14. Next i
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement