Advertisement
Guest User

maridan chocolate chip

a guest
May 8th, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub Shifting()
  2. Dim s1 As Worksheet, s2 As Worksheet, lastrow As Integer, lastrow3 As Integer
  3.  
  4. Set s1 = Sheets("Sheet2")
  5. Set s2 = Sheets("Sheet3")
  6. lastrow = Sheets("Sheet2").Cells(Rows.Count, "C").End(xlUp).Row
  7. lastrow3 = Sheets("Sheet3").Cells(Rows.Count, "A").End(xlUp).Row
  8. s1.Range("C2:C2000").Copy s2.Range("lastrow3" & lastrow)
  9. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement