Copying and pasting links to other worksheets within the same work
 

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

Copying and pasting links to other worksheets within the same work
 

Hi,

The first case can be solved with

=INDIRECT("Sheet3!B"&COLUMN(D:D))

Where Sheet3!B4 is the first cell with data which you want on the sheet
where the formula above is placed. Copy it to the right to column K or
whatever.


--
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

Copying and pasting links to other worksheets within the same work
 

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