how do I automatically repeat data in several excel workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
Code to format cells on several worksheets 2
Start sheet in a workbook 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
linking workbooks - Help needed ASAP 6
Summarise data from several worksheets in a workbook 2
Linking data within several Workbooks 1
Combining data from 6 workbooks into one master 1

Back
Top