Advertisement
Guest User

Untitled

a guest
Jul 16th, 2019
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. Dim src As Worksheet
  2. Dim trg As Worksheet
  3. Dim LastRow As Long
  4.  
  5. Set src = ThisWorkbook.Worksheets("Report0")
  6. Set trg = ThisWorkbook.Worksheets("Report1")
  7.  
  8. src.Range("A:A").Copy Destination:=trg.Range("A1")
  9. src.Range("D:D").Copy Destination:=trg.Range("B1")
  10. src.Range("B:B").Copy Destination:=trg.Range("C1")
  11. src.Range("H:H").Copy Destination:=trg.Range("D1")
  12. src.Range("J:J").Copy Destination:=trg.Range("E1")
  13. src.Range("G:G").Copy Destination:=trg.Range("F1")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement