deshall

You can "link" workbooks together so when you update one the others will be
updated.

OR........You could combine the workbooks into one workbook with several
worksheets and link the cells in sheets to one sheet.

Your choice. The latter is easiest to maintain in most cases.

See Help on "linking" and "Create a link to another cell, workbook, or
program".

Gord Dibben Excel MVP

On Tue, 7 Dec 2004 13:23:02 -0800, "deshall"
wrote:

In excel I have several files in which there are areas where data is entered
on a regular basis. To save effort I would like to enter data in one file and
have it also enter into another file. Can I by using separate sheets in the
first file by combining the files and therefore have one lot of enteries?