Paste, then skip two lines, and paste again

[melnemac32]

Hello,

When I upload a report for all of my workcenters my week list comes out looking like this:

30/04/2013 04/05/2013
05/05/2013 11/05/2013
12/05/2013 18/05/2013
19/05/2013 25/05/2013
26/05/2013 01/06/2013
02/06/2013 08/06/2013
09/06/2013 15/06/2013
16/06/2013 22/06/2013
23/06/2013 29/06/2013
30/06/2013 06/07/2013
07/07/2013 13/07/2013
14/07/2013 20/07/2013
21/07/2013 27/07/2013
28/07/2013 03/08/2013
04/08/2013 10/08/2013
11/08/2013 17/08/2013
18/08/2013 24/08/2013
25/08/2013 31/08/2013
01/09/2013 07/09/2013
08/09/2013 14/09/2013
15/09/2013 21/09/2013
22/09/2013 28/09/2013
29/09/2013 05/10/2013
06/10/2013 12/10/2013
13/10/2013 19/10/2013

I want to change these from this format to say Week 1, Week 2, Week 3, and etc... I have several workcenters that are printed off. I would to be able to paste in Week 1 - Week 25, then say skip 4 lines, and paste again. My weeks start in cell A4 and end in A29. My next week section starts again on cell A33. The number of lines that I will have will change every week.


I have posted an example of what I am hoping for.