Hi
I have been trying to link one sheet to another, sya I have a column in one sheet that I want gets updated automatically in another sheet, I am designing a timesheet, I have designed an individual timesheet for every employee, now I want to link their timesheet to a sheet called project manager. In project manager I have information about projects. I don't know if it is possible to link time spend by each employee into new worksheet, and then compare it with number of days predicted and number of days spent by employee, it is just a uni assignment I am working on.
Appreciate any suggestion
Thanks
Nick

In your formula, just insert the target spreadsheet name followed by an exclamation point in front of the target cell. For example, is the time sheet name is "Sam" and you want cell B4 from Sam in the new sheet "Project Manager" you would enter the following in one of the cells on the Project Manager worksheet:

=Sam!B4

Want to add two different time sheet values?

=Sam!B4 + Ted!C12

You may also want to search Microsoft's template web site at
http://office.microsoft.com/en-us/te...s/default.aspx

They may have something close to what you are looking for. I typed in "excel timesheet" and it returned about a dozen samples.