I've got the following database details in a sheet called Database3, that
shows employee numbers and dates that they have clocked in

Col A Col B

1 11/04/05
1 12/04/05
1 13/04/05
2 12/04/05
2 14/04/05
3 11/04/05

I'm looking for a piece of code that will copy only the employee number to a
ceratin cell in worksheet "reports". I therefore need the code to work
through the detail above and everytime it finds a "new" employee number to
copy this 12 cells below where the first cell was copied in "Reports C11".
Thus what I would expect to see within the Reports worksheet in the
appropriate cells would be

C11 = 1
C23 = 2
C35 = 3

It would finally get to the end of the database at then just stop

Hope someone can assist

Thanks