Help!!!!!!

[Maths]

Pls pls pls take time to read this:

I need to link the values in two separate sheets of the same file. The
data that i enter in sheet 1must appear in sheet 2 as follows.

the values i enter in A1 must come in A1
A2 must come in A6
A3 must come in A11
A4 must come in A16.
the values are to appear in the second sheet with a gap of 5 rows
between them.

but if i just copy and paste the formula, A1 would be linked to A1,
but A6(sheet 2) would be linked to A6(sheet 1) and not A2.

Is there any way i can get this done without having to type the
formulas individually in each cell.

Pls HELP!!!!!

 

[Bernie Deitrick]

In A1 of Sheet 2, enter the formula

=INDEX(Sheet1!A:A,INT(ROW()/5)+1)

Then copy A1:A5 (with A2 to A5 still blank) and paste to A6:AXXX where XXX
is a multiple of 5.


HTH,
Bernie
MS Excel MVP

 

[Maths]

In A1 of Sheet 2, enter the formula

=INDEX(Sheet1!A:A,INT(ROW()/5)+1)

Then copy A1:A5 (with A2 to A5 still blank) and paste to A6:AXXX   where XXX
is a multiple of 5.

HTH,
Bernie
MS Excel MVP

Got it......
THANX A LOT