ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel (https://www.excelbanter.com/excel-worksheet-functions/46992-excel.html)

sartiag

Excel
 
I am trying to make up new employee time sheets. What I am wanting to do is
when I enter all the hours on each individual sheet for a project the actual
hour will convert over to the project hours sheet at the same time. How do I
do this.

Thanks

Gary''s Student

You need to link the data.

Go to an individual's time sheet and copy a cell you want to carry over.
The go to the Project sheet and select the destination cell. Then paste
Special and check the link button.
--
Gary''s Student


"sartiag" wrote:

I am trying to make up new employee time sheets. What I am wanting to do is
when I enter all the hours on each individual sheet for a project the actual
hour will convert over to the project hours sheet at the same time. How do I
do this.

Thanks



All times are GMT +1. The time now is 12:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com