Excel 2003: Linking a whole row or column to another worksheet

[Dan]

Hi,
I am trying to link rows and column from one worksheet to another. So far I
can only figure out how to do this one cell at a time and when I highlight
the whole area that I want to link it just links the first cell in that row
or column. I have a lot of data so doing this individually is not practical.
Can anyone help me?

 

[Shane Devenshire]

Hi,

When you highlighted a range choose Copy, the move to the first cell you
want to have a link in and choose Edit, Paste Special, Paste Link.

 

[Bernie Deitrick]

Dan,

You can create links to multiple cells by first selecting all the cells that you want to link. In
the formula bar, type = and then navigate to the first cell that you want to link to and select it.
(If the address comes up with $, press F4 until the $s go away) and then press Ctrl-Enter.

HTH,
Bernie
MS Excel MVP

 

[Dan]

I did work but it also put zeros in the blank cells

 

[Gord Dibben]

can only figure out how to do this one cell at a time

In A1 of Sheet2 enter =IF(Sheet1!A1="","",Sheet1!A1)

Simply drag/copy across and down.

Adjust cell references to suit your needs.


Gord Dibben MS Excel MVP

 

[Bernie Deitrick]

An alternative to the IF(cell = "","",cell) that Gord offers is to first copy all the cells from the
source sheet, and paste values onto the sheet where you want the links. Then select all the cells
and use Edit / Go to... Special Constants OK to just select the cells with values, then note
the active cell, and type =, then navigate to the same cell on the source sheet, make sure that the
$s are not used, and press Ctrl-Enter.

HTH,
Bernie
MS Excel MVP