Copy data between two worksheets

Sheet1 has a list of times in a column in sequence from 8:00am to 9:00pm in half hour intervals.

Sheet2 has a list of times in a column with additional data in the rows. The times on sheet2 are random.

I would like to copy the data from sheet2 from each time into the corresponding time row on sheet1.

Nick's picture

http://excelexperts.com/Excel