 |
|
| Browse | Ask | Answer | Search | Join/Login |
|
|
||||
|
Timesheet assignment
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. |
||||
| Question Tools | Search this Question |
Add your answer here.
Check out some similar questions!
Hi, I'm currently studying Forensic Science at College in England, and I was wondering if you could give me some pointers on an assignment I have as we have had very little guidance on it. The task is to review the types of energy (I believe this means kinetic, potential etc.), their...
What are your legal duties for health and safety in the work place under the health and safety act 1974? What are your legal duties for health and safety as defined by any specific legislation covering your job role? Name 3 things that you might find on an agreed workplace policy relating to...
Another movie which I saw in my teens and would like to revisit was something about 3 people who have esp abilities. The title which crops up is "The Assignment" but I'm not really sure. These 3 people were sent on a mission and they use esp to complete the job. Thanks.
Hi I have this english assignment and I need to know a law about make-up I'm not so sure if there is one but maybe some of the other members could clarrify this My question really is there any legal limits on make-up? Thank you if you reply I'm hoping for an A+:)
View more questions Search
|
