Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. If Sheets("hour report").Range("U1") = 1 Then
  2. For i = 1 To k3
  3. For n = 1 To k1
  4. Sheets("Sheet1").ListObjects("Table1").Range.AutoFilter Field:=1, _
  5. Criteria1:=Sheets("hour report").Range("B" & i + 1)
  6. Sheets("Sheet1").ListObjects("Table1").Range.AutoFilter Field:=2, _
  7. Criteria1:=Sheets("hour report").Cells(1, n + 2)
  8.  
  9. On Error Resume Next
  10. Range("Table1[f1]").SpecialCells(xlCellTypeVisible).Copy
  11. Sheets("hour report").Activate
  12. Cells(i + 1, n + 2).Select
  13. ActiveSheet.Paste
  14. Next n
  15. Next i
  16. End If
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement