Update multiple workbooks automatically

G

golfer

IS there some way to create a workbook or data base in excel that will
automatically flow to other workbooks, data bases? What I want to do is enter
the information one time and have it automatically update 3 or more
workbooks, spread sheets etc...
 
P

Peo Sjoblom

You have to create all the links first like

=[main_workbook]Sheet1!$C$1

and so on, once that is done all the changes you make to the
main workbook will be reflected in the other workbooks

Regards,

Peo Sjoblom
 

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

Top