Link Rows Between Worksheets

V

veng

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

exceluserforeman

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

veng

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

Gord Dibben

Select the entire row(s) and Copy.

Switch to other sheet and Paste Special>Paste Link>OK>Esc.


Gord Dibben Excel MVP
 
Top