In Sheet6,

Place this in any starting cell, say, in B2:
=INDEX(Sheet2!A:A,ROWS($1:1)*7-6)
Copy B2 down as far as required.

B2 returns the same as: =Sheet2!A1
B3 returns the same as: =Sheet2!A8
and so on
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"pcor" wrote:
I have numbers on SHEET2 that are all 7 cells apart:
A1
A8
A15
A22
etc
I want to create a chart on sheet 6 so I have copied the coordinate as such
yo shhet 6
=Sheet2!:a1
=sheet2!a8
etc etc
Is there a way that this could be done jmucg faster and better as my list is
becoming very long.
Thanks