From the spreadsheet(SS-1) below I would like to copy the data from every
third line (COL-1, COL-4,COL-5) into another spreadsheet(SS-2). In SS-1
COL-4 & COL-5 are the average of the three entries in COL-2 & COL-3. I tried
to enter the formulas in the first row of SS-2, then copy them down to the
bottom of the SS, but since I only want data from every third linne in SS-1,
the formulas don't copy like I want. I even used a macro to delete all but
every third row in SS-2, but that seems rather awkward.

Any suggestions?
k1ngr
=====================================
(SS-1)
COL-1 COL-2 COL-3 COL-4 COL-5
1/1/08 140 80
1/1/08 130 85
1/1/08 120 90 130 85
1/5/08 112 72
1/5/08 117 73
1/5/08 111 79 113 75
=====================================
(SS-2)
COL-1 COL-2 COL-3
1/1/08 130 85
1/5/08 113 75
=====================================