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

Assume source sheet is named as: A

In sheet: B,
Put in B1: =INDIRECT("'A'!E"&ROW(A1)*8-8+7)
Put in C1: =OFFSET(A!$H$6,ROW(A1)*8-8+COLUMN(A1)-1,)
Copy C1 to E1
Then just select B1:E1 and fill down until zeros appear
signalling exhaustion of data extract

I've left the formulas above as-is, ie without further arithmetic
simplification, to better illustrate the pattern for easier understanding &
adapting to other situations. Here, it is 8 rows in-between groups of data.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
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

"Eric" wrote:
Thank you very much

Pleasure` Eric !
Thanks for the note-back ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---