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?

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.

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

Cheers,
Shane Devenshire


"Dan" wrote:

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?

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" wrote in message
...
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?

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

"Bernie Deitrick" wrote:

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" wrote in message
...
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?

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

On Tue, 16 Jun 2009 11:12:01 -0700, Dan
wrote:

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

"Bernie Deitrick" wrote:

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" wrote in message
...
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?

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


"Dan" wrote in message
...
I did work but it also put zeros in the blank cells

"Bernie Deitrick" wrote:

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" wrote in message
...
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?