I was wondering if anyone could help:

I would like to make a list referencing cells equidistantly apart:

In sheet 2 i am interested in a value every 40 rows apart and in the other
sheet 1 I would like to make a list of those values every row:

In sheet 1:

A1 =Sheet2!A1
A2 =Sheet2!A41
A3 =Sheet3!A81

and so on...can anyone help?

Try

=INDIRECT("Sheet2!A"&1+(ROW()-1)*40)

in A1 on Sheet1 and copy down as needed.

Hope this helps,

Hutch

"Liam" wrote:

I was wondering if anyone could help:

I would like to make a list referencing cells equidistantly apart:

In sheet 2 i am interested in a value every 40 rows apart and in the other
sheet 1 I would like to make a list of those values every row:

In sheet 1:

A1 =Sheet2!A1
A2 =Sheet2!A41
A3 =Sheet3!A81

and so on...can anyone help?

On Jun 12, 10:04 pm, Liam wrote:
I was wondering if anyone could help:

I would like to make a list referencing cells equidistantly apart:

In sheet 2 i am interested in a value every 40 rows apart and in the other
sheet 1 I would like to make a list of those values every row:

In sheet 1:

A1 =Sheet2!A1
A2 =Sheet2!A41
A3 =Sheet3!A81

and so on...can anyone help?

This formula in A1 should do it:
=INDIRECT("sheet2!a" &(ROW()*40)-39)

Per Erik

Another one:

Entered in A1 and copied down:

=INDEX(Sheet2!A:A,ROWS(A$1:A1)*40-39)

--
Biff
Microsoft Excel MVP


"Liam" wrote in message
...
I was wondering if anyone could help:

I would like to make a list referencing cells equidistantly apart:

In sheet 2 i am interested in a value every 40 rows apart and in the other
sheet 1 I would like to make a list of those values every row:

In sheet 1:

A1 =Sheet2!A1
A2 =Sheet2!A41
A3 =Sheet3!A81

and so on...can anyone help?

Thank you very much...you have saved me a lot of time!

"Tom Hutchins" wrote:

Try

=INDIRECT("Sheet2!A"&1+(ROW()-1)*40)

in A1 on Sheet1 and copy down as needed.

Hope this helps,

Hutch

"Liam" wrote:

I was wondering if anyone could help:

I would like to make a list referencing cells equidistantly apart:

In sheet 2 i am interested in a value every 40 rows apart and in the other
sheet 1 I would like to make a list of those values every row:

In sheet 1:

A1 =Sheet2!A1
A2 =Sheet2!A41
A3 =Sheet3!A81

and so on...can anyone help?