Link Rows Between Worksheets
 

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..

Link Rows Between Worksheets
 

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..

Link Rows Between Worksheets
 

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..

Link Rows Between Worksheets
 

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..