This is my example data, it shows employees and the quality of their work, this changes from day to day. But I need to record the quality of each employee for each day of the month. What I have been able to do create the formula below so that it stores the the quality of each employee for a particular day. eg. below shows the data for 21/01/05 for each employee,I want that data to be then trans to the janaury sheet so for that day it records the quality of that employees, but when the date changes say to 22/01/05 it then records the data for that day in the cell next in the janury sheet. So for each employee it will show the quality of each employees work for each day of month. And when the month changes it will then store data in the feb sheet. I hope this makes sense. I've tried using if statements so that when the date changes it keeps the that was lst updated but thiscreates a circular reference, whic is not a problem for me but other people using this will no know whats going on..Hope someone can help..tjugh my head is now spinning and i'm gonna lie down

Cheers
Balcardi

Sheet1 F1=21/01/05

Name Quality

David E13=20%
Tom 30%
Paul 33%
Kevin 12&

January

21/01/05 David
b1=20%


=IF(Sheet1!F1=DATE(2005,1,21), Sheet1!E13,b1)