Steps in vba

Hi Aquila, thanks for your query. Set up a loop down through your data (i.e. something like For NumRows = 1 To ....CurrentRegion.Rows.Count) and put "Step 5" at the end. Then within the loop put your copying code. That code will then only apply to every 5th row.

Hope this helps, let me know how you get on.

Anthony