Hi,

What I am trying to do is to create an auto fill formula.


I have 4 sheets, the first is called 2012 and is a calendar, the other 3 are one for each of the 3 projects (project 1, 2,3)

In the first sheet I have a timesheet schedule with : one column (scroll down list) with the project name
another column (scroll down list) with the workpackage
and afterwards the days of the month.

What I want to do is , depending which project and workpackage you have selected from the first two columns the total of the hours you have placed under the days of the month to be put to the equivalent sheet of the project.

What formula do I use in order once you have chosen your project and w/p all the hours to be put in one cell at the equivalent project sheet ???