Hi
I have two excel documents that i require to be linked. The first one is a list of employees with the hours of work pr week. The other one is a summary of this.
The format of the employee list is set out with employee names down the lft hand side by weekly basis
03/09 10/09 17/09 23/09
John B 5.00% 0.00% 6.25% 9.03%
Dan H 12.00% 20.00% 15.79% 11.22%
Dan J 8.70% 22.22% 25.00% 14.96%
Steve 30.43% 30.43% 23.81% 32.15%
What i would like in the summary sheet is a function where you can select the date from a drop down list and it displays the value from the employee worksheet for that particular date.
Can anyone help. Thanks.
Bookmarks