Hi
I am trying to copy a specific row number with a range of columns to the next available row on another worksheet.
This is what I have right now:
For timeKeeper2 = 2 To counter6 - 1
If Worksheets(3).Cells(timeKeeper, 19) = "" Then
Worksheets(3).Range(timeKeeper2, "B10:E10").Select
Selection.Copy
Worksheets(Worksheets(3).Cells(timeKeeper, 1).Text).Activate
Worksheets(Worksheets(3).Cells(timeKeeper, 1).Text).Range("A" & Rows.Count).End(xlUp).Offset(1).Select
ActiveSheet.Paste
End If
Next
However, it does not seem to know where I am referencing. Anyone have ideas on how to solve this?
Bookmarks