I want to link a group of incontinuous cells, say B1,B4,B7,B10,B13 on sheet2,
to A1:A5 on sheet1. Is there a simple and convenient way to deal with
problems like this? Any help greatly appreciated.

I've found the answer from the listed topics, which said we can use indirect
or offset function to do this. But I am still puzzled about following
problem, please help me out, thanks in advance.

A1='sheet2'!A3
A2='sheet2'!D3
A3='sheet2'!G3
A4='sheet2'!J3
..
..
..

How can I use the indirect or offset function to make this easier? Thank you!
"Leonard Lan" wrote:

I want to link a group of incontinuous cells, say B1,B4,B7,B10,B13 on sheet2,
to A1:A5 on sheet1. Is there a simple and convenient way to deal with
problems like this? Any help greatly appreciated.

B1,B4,B7,B10,B13 on sheet2,
to A1:A5 on sheet1

Enter this formula on Sheet1 A1 and copy down as needed:

=INDEX(Sheet2!B:B,ROWS(A$1:A1)*3-2)

A1='sheet2'!A3
A2='sheet2'!D3
A3='sheet2'!G3
A4='sheet2'!J3

Enter this formula on Sheet1 A1 and copy down as needed:

=INDEX(Sheet2!$3:$3,ROWS(A$1:A1)*3-2)


--
Biff
Microsoft Excel MVP


"Leonard Lan" wrote in message
...
I want to link a group of incontinuous cells, say B1,B4,B7,B10,B13 on
sheet2,
to A1:A5 on sheet1. Is there a simple and convenient way to deal with
problems like this? Any help greatly appreciated.

Your answer is great! It saved me thousands of minutes. Excel is a wonderful
tool. Thanks again for your great help.

"T. Valko" wrote:

B1,B4,B7,B10,B13 on sheet2,
to A1:A5 on sheet1

Enter this formula on Sheet1 A1 and copy down as needed:

=INDEX(Sheet2!B:B,ROWS(A$1:A1)*3-2)

A1='sheet2'!A3
A2='sheet2'!D3
A3='sheet2'!G3
A4='sheet2'!J3

Enter this formula on Sheet1 A1 and copy down as needed:

=INDEX(Sheet2!$3:$3,ROWS(A$1:A1)*3-2)


--
Biff
Microsoft Excel MVP


"Leonard Lan" wrote in message
...
I want to link a group of incontinuous cells, say B1,B4,B7,B10,B13 on
sheet2,
to A1:A5 on sheet1. Is there a simple and convenient way to deal with
problems like this? Any help greatly appreciated.

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Leonard Lan" wrote in message
...
Your answer is great! It saved me thousands of minutes. Excel is a
wonderful
tool. Thanks again for your great help.

"T. Valko" wrote:

B1,B4,B7,B10,B13 on sheet2,
to A1:A5 on sheet1

Enter this formula on Sheet1 A1 and copy down as needed:

=INDEX(Sheet2!B:B,ROWS(A$1:A1)*3-2)

A1='sheet2'!A3
A2='sheet2'!D3
A3='sheet2'!G3
A4='sheet2'!J3

Enter this formula on Sheet1 A1 and copy down as needed:

=INDEX(Sheet2!$3:$3,ROWS(A$1:A1)*3-2)


--
Biff
Microsoft Excel MVP


"Leonard Lan" wrote in message
...
I want to link a group of incontinuous cells, say B1,B4,B7,B10,B13 on
sheet2,
to A1:A5 on sheet1. Is there a simple and convenient way to deal with
problems like this? Any help greatly appreciated.