automatically updating cells in other files

  • Thread starter Thread starter Peter McCaul
  • Start date Start date
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.
 
You can link cells by referencing them to a cell in another sheet or
workbook. eg =[Book2]Sheet1!$A$1
 
Back
Top