I have a macro that works fine I would just like to fine tune it so that it works more efficiently.
Currently it completes the same step 19 times (every 12th row), however, most of the time it only needs to complete 12 times but can vary from 6 to 33.

Any help in shortening the code to reflect the repeat steps and additional code to find the last row in the range and only complete until it reaches the last row would be much appreciated.



A snippet of the code:

Range("U3:AL3").Select
 Selection.Cut
Range("C4").Select
 ActiveSheet.Paste
Range("C4:T4").Select
 Selection.AutoFill Destination:=Range("C4:T13"), Type:=xlFillCopy
 Range("C4:T13").Select
Range("U15:AL15").Select
Selection.Cut
Range("C16").Select
ActiveSheet.Paste
Range("C16:T16").Select
Selection.AutoFill Destination:=Range("C16:T25"), Type:=xlFillCopy
Range("C16:T25").Select