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?

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?

I think what you may have in mine is having say 12 sheets for the year and on
each sheet have the same basic information on all 12 sheets in the same place
so that you don't have to type it over again each month? The remaining areas
you have the monthly information as you go along Let me knwo if this is what
you need.

"Gord Dibben" wrote:

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?