automatically updating cells in other files

P

Peter McCaul

An employee asked me if he had 3 files each containing the same database.
Is there anyway in which he can update the data by only keyboarding it into
one file and have it automatically update the rest of files?

Any help is appreciated.
 
I

Ian

You can link cells by referencing them to a cell in another sheet or
workbook. eg =[Book2]Sheet1!$A$1
 

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

automatically updating cells in other files. 2
Counting multiple memberships 1
somewhat complicated conditional formula 2
Excel 2007 - Automatically Updating Links! 3
excel external data range failed to refresh - second try 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Make Excel 2003 auto upate cell caluclations 3
Excel Referencing one cell from a different worksheet and slide in powerpoint 0

Top