Then perhaps just a slight tweak ..

In B7, copied down:
=IF(OR(MOD(ROW(A1)-1,8)={6,7}),A7,OFFSET(INDIRECT("A"&INT((ROW(A1)-1)/8)*8+7),,))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dave Peterson" wrote in message
...
I thought that there might be existing data that should be touched (the
reason
for skipping a couple of rows).