Select the source range and copy it. Select the first cell in the
destination range and then Edit, Paste Special and click the Paste Link
button.

--
Jim
"chris c" wrote in message
...
| can anyone help? I am trying to link a whole worksheet, I have done a =
and
| pasted the reference from the source location but that only gives me a
| specific cell from that source. I was hoping it would paste the whole
| worksheet from the source, is this possible? I do not wish to use the
embed
| option and I do not want to paste a cell by cell reference, I need the
entire
| sheet or optionally an named/titled area, eg print area....
|
| Chris