Just in case you want to go with clearing "Server Pay Sheet" first, something like this would probably do it.
This code can be run from any sheet. You don't have to be in "Check's" sheet
Sub Maybe_A()
Dim lr As Long, i As Long, b As Long, a(), j As Long, sh1 As Worksheet, sh2 As Worksheet
Set sh1 = Sheets("Check's")
Set sh2 = Sheets("Server Pay Sheet")
sh2.Range("A1:A" & sh2.Cells(Rows.Count, 1).End(xlUp).Row).Offset(2).Resize(, 7).ClearContents
lr = sh1.Cells(Rows.Count, 10).End(xlUp).Row
For i = 3 To lr
b = sh1.Cells(i, 10).Value
a() = Array(sh1.Cells(i, 1).Value, sh1.Cells(i, 2).Value, sh1.Cells(i, 3).Value, sh1.Cells(i, 4).Value, sh1.Cells(i, 10).Value, sh1.Cells(i, 9).Value / b)
For j = 1 To b
With sh2
.Range("A" & .Rows.Count).End(xlUp)(2).Resize(, 6) = a
End With
Next j
Next i
End Sub
Bookmarks