how do I automatically repeat data in several excel workbooks

S

sjhartley99

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

icestationzbra

if the data in cell A1 of Sheet1 is to appear in cell A1 on both Sheet
and Sheet3, that could be done by providing the formula in Sheet2 an
Sheet3 by using the formula =Sheet1!A1
 
V

Voodoodan

If you highlight all the sheets you want to update, click on you
'master sheet' and type in the info. This will appear on the othe
highlighted sheets.

Dan
 
Top