Chart on a different sheet
 

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

Chart on a different sheet
 

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

Chart on a different sheet
 

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

"Max" wrote:

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

Chart on a different sheet
 

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

--
Regards,

Peo Sjoblom


"pcor" wrote in message
...
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

"Max" wrote:

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

Chart on a different sheet
 

Your help is much appreciated

"Peo Sjoblom" wrote:

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

--
Regards,

Peo Sjoblom


"pcor" wrote in message
...
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

"Max" wrote:

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

Chart on a different sheet
 

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

"Peo Sjoblom" wrote:

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

--
Regards,

Peo Sjoblom


"pcor" wrote in message
...
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

"Max" wrote:

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

Chart on a different sheet
 

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" wrote in message
...
What code would I require if I wanted to start at Col D row 200 and work
down
Thanks

"Peo Sjoblom" wrote:

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

--
Regards,

Peo Sjoblom


"pcor" wrote in message
...
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

"Max" wrote:

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

Chart on a different sheet
 

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

"Peo Sjoblom" wrote:

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" wrote in message
...
What code would I require if I wanted to start at Col D row 200 and work
down
Thanks

"Peo Sjoblom" wrote:

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

--
Regards,

Peo Sjoblom


"pcor" wrote in message
...
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

"Max" wrote:

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