Select the entire row(s) and Copy.

Switch to other sheet and Paste SpecialPaste LinkOKEsc.


Gord Dibben Excel MVP


On Wed, 7 Dec 2005 06:42:02 -0800, "veng"
wrote:

Thank you for your reply, Exceluserforeman.
This allows me to link individual cells at a time; is there a way to link
whole rows?
Thanks again....


"exceluserforeman" wrote:

In the other sheets you will have to set then up

eg: in sheet2 select the cell you want then type an equals sign =

got to master sheet and selec tthe cell you want then press enter key.



"veng" wrote:

Hi-
I am trying to link rows (that are infinitely long in terms of data) between
two different worksheets so that I dont have to retype all of the data. (I
want them to be active links, so that if the data changes, it will
automatically update). Is there a way to do this?
(The first worksheet is a master that has a whole lot of information, and I
would like the other worksheets to reference rows from the original...)

Thank you very very much..