View Single Post
  #6   Report Post  
bigwheel
 
Posts: n/a
Default Copy an additional row based on another sheet

OK try it in this order:-

If Range("Tuesday!A5") = 1 Then
ActiveCell.EntireRow.Copy

Sheets(3).Select 'insert this new line

Range("TuesdayDateCodes!A6").Select
ActiveCell.Offset(1).EntireRow.Insert
Application.CutCopyMode = False
End If

and rename your sheet, taking out the hyphens i.e. TuesdayDateCodes