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

--
Ian
--
"Peter McCaul" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>