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.