Try adapting TM's idea like this ..
Put in the start cell, eg in B346, then copy down:
=INDEX($A$346:$A$375,(ROWS($1:1)+1)/2)

Above tested ok here. Celebrate your success,
click the YES button below and in TM's response
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"Dingerz" wrote:
I have got it to work
=INDEX($A$346:$A$375,1/2)
But its not doing what i wanted and only copying 1 cell over and over again