See Excel's Help on "Create a link to another cell, workbook, or program"

You can link one cell to another in the same sheet, a different sheet or a
different workbook.

Note the info on "updating links" between workbooks.


Gord Dibben MS Excel MVP

On Thu, 7 Dec 2006 08:45:01 -0800, Losva
wrote:

I am doing a survey on a monthly basis. I have one sheet for each day and one
sheet for the output data from each day. I want to know if there is a way for
me to have the "output sheet" update automaticly as I enter data on the "day
sheets" ?

And question number two: Is there a way to get a separate workbook to update
automaticly with the data I enter in other workbooks?

I'm not the most experienced Excel-user so any explanations/help posted
shoud be very step-by-step...

Would apreciate any help or hints of where I can find answer to these
questions!