Unless MS provided some mechanism, it is a surprisingly simple way IMO. You
need to get the data from somewhere, such as the Navy clock, then parse it
and apply it.

On the second bit, you need to loop through all the items, match it against
the second sheet, and if matched, copy it. Something like this one that I
provided for someone earlier

Sub Test4Ed()
Dim sh1 As Worksheet
Dim sh2 As Worksheet
Dim iLastRow As Long
Dim iPos As Long
Dim i As Long

Set sh1 = Worksheets("Sheet1")
Set sh2 = Worksheets("Sheet2")

With sh1
iLastRow = .Cells(.Rows.Count, "D").End(xlUp).Row
For i = 1 To iLastRow
iPos = 0
On Error Resume Next
iPos = Application.Match(.Cells(i, "D").Value, _
sh2.Range("D:D"), 0)
On Error GoTo 0
If iPos > 0 Then
sh2.Cells(iPos, "A").Resize(, 3).Copy .Cells(i, "A")
End If
Next i
End With

End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"cliodne" <[email protected]> wrote in
message news:[email protected]...
>
> Thanks Bob
>
> wow, for that time synchronizing, I thought there would be a simpler
> way.
>
> For the matching issue, I'm still confused. I know the functions that
> would enable me to be able to match data from a single sheet using the
> match, vlookup function, but I don't see how I can use them to take
> data from two different sheets, match the values (5 out of 5, 4 out of
> 5, 3 out of 5, 2 out of 5, 1 out of 5) and compile them into a third
> sheet in that order.
>
> Cami
>
>
> --
> cliodne
> ------------------------------------------------------------------------
> cliodne's Profile:
http://www.excelforum.com/member.php...o&userid=28774
> View this thread: http://www.excelforum.com/showthread...hreadid=484627
>