Below I am trying to use Vlookup, Hlookup and Match to populate time sheets with each employees 'Planned' hours as anticiapted at the beginning of the year. Then each employee will be given a time sheet with what activities they are support to work on (again, Planned hours). Then collection of time will take place each week and variance to be reviewed for project impacts. Problem is, I have been unable to figure out the code. Thoughts from anyonr?
Thanks in advance,
Keith

Time Sheet - Employee 1
Actuals fw1 fw2 fw3
Planned Actual Variance Planned Actual Variance Planned Actual Variance
Employee 1 0 0 0
Employee 2 0 0 0
Employee 3 0 0 0
Employee 4 0 0 0


Separate Spreadsheet

Planned Hours fw1 fw2 fw3 fw4
Employee 1 4 5 6 8
Employee 2 5 6 8 4
Employee 3 6 8 4 5
Employee 4 8 4 5 6