Hi,

One solution for the second problem is to enter the following formula in C4:

=OFFSET(Sheet1!$F$2,0,2*(ROW(A1)-1))

copy down.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"GEwan" wrote:

Hi,
I'm trying to link one of my worksheets to other worksheets within the same
workbook. The source data on the other worksheets is not in a set structure
of rows/columns. Is there a quick and easy way to do this?
Example1, the Destination for one set of data is B4:B11 and the source data
is on a separate worksheet D4:K4. When I try to use Transpose, the ability to
Link goes away...
Example2, the Destination for another set of data is C4:C11 and the source
data is on a separate worksheet F2, H2, J2, L2, N2, etc.
Thanks!
G