Link problem

[Leonard Lan]

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.

 

[Leonard Lan]

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!

 

[T. Valko]

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)

 

[Leonard Lan]

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

 

[T. Valko]

You're welcome. Thanks for the feedback!