Chart on a different sheet

[pcor]

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

 

[Max]

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

 

[pcor]

Thanks for the help. I would apperciate it if you would explain the folllowing:
I assume ($1:1) refers to A1
what does the " *7-6" do
thanks

 

[Peo Sjoblom]

1:1 refers to the first row and returns 1, *7-6 means multiply 1 (what rows
return) by 7 then subtract 6
that part will return 1,8,15 and so on

 

[pcor]

Your help is much appreciated

1:1 refers to the first row and returns 1, *7-6 means multiply 1 (what rows
return) by 7 then subtract 6
that part will return 1,8,15 and so on

 

[pcor]

What code would I require if I wanted to start at Col D row 200 and work down
Thanks

 

[Peo Sjoblom]

It should be the same, that's the beauty of using rows as opposed to row.

Of course if you meant that you want to get the first value from Sheet2!D200
then just change it to


=INDEX(Sheet2!$D$200:$D$65535,ROWS($1:1)*7-6)


and copy down


but if you mean that you want to put this formula in D200 then it would be
unchanged


--
Regards,

Peo Sjoblom

 

[pcor]

That was just great.Thanks- I was looking for the "FIRST"