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?