how do I automatically repeat data in several excel workbooks

S

stufroments

I am trying to update the same text / numerical data in 3 different workbooks
at one, can anyone help? Eg, if I input a name in one sheet I want it to
appear in all 3.
 
F

Frank Kabel

Hi
you can link the other workbooks to this cell. e.g.
- select the target cell and enter the equation sign '='
- now select with your mouse the sourc e cell and hit ENTER
 
Top