There are 2 worksheets A and B. Worksheet A contains many groups of data,
such as Name, Age, Sex, Address, ... which locate on different cell position,
E7, H6, H7, H8, and the same information for next group will locate on E15,
H14, H15, H16.

I would like to link
A!E7 into B1
A!H6 into C1
A!H7 into D1
A!H8 into E1

A!E15 into B2
A!H14 into C2
A!H15 into D2
A!H16 into E2

and I would like to do the rest, but I cannot link the rest of cells by
dragging B1:E2 into E100, each cell just does not align with my intended cell
value.
Does anyone know on how to do it in Excel?
Thank you in advance
Eric

B1: =INDIRECT("A!E" & ROW()*8-1)
C1: =INDIRECT("A!H" & ROW()*8-2)
D1: =INDIRECT("A!H" & ROW()*8-1)
E1: =INDIRECT("A!H" & ROW()*8)

and copy down as far as needed

HTH,
Bernie
MS Excel MVP


"Eric" wrote in message
...
There are 2 worksheets A and B. Worksheet A contains many groups of data,
such as Name, Age, Sex, Address, ... which locate on different cell position,
E7, H6, H7, H8, and the same information for next group will locate on E15,
H14, H15, H16.

I would like to link
A!E7 into B1
A!H6 into C1
A!H7 into D1
A!H8 into E1

A!E15 into B2
A!H14 into C2
A!H15 into D2
A!H16 into E2

and I would like to do the rest, but I cannot link the rest of cells by
dragging B1:E2 into E100, each cell just does not align with my intended cell
value.
Does anyone know on how to do it in Excel?
Thank you in advance
Eric

Thank you very much
Eric