Advertisement
Guest User

Untitled

a guest
Jan 21st, 2020
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. Private Sub CommandButton1_Click()
  2.  
  3. lastRow = Worksheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row
  4.  
  5. For i = 1 To lastRow Step 94
  6. Worksheets("Sheet1").Rows(i).Copy
  7.  
  8. Worksheets("Sheet2").Activate
  9. lastRowSheet2 = Worksheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Row
  10.  
  11. Worksheets("Sheet2").Range("A" & lastRowSheet2 + 1).Select
  12.  
  13. ActiveSheet.Paste
  14.  
  15. Worksheets("Sheet1").Activate
  16.  
  17.  
  18. Next i
  19. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement