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.

Hi koiman, are the random times in sheet2 also 1/2 hours ?
Or is it just to place all times from sheet2 that fall on the intervals?

Originally Posted by rcm

Hi koiman, are the random times in sheet2 also 1/2 hours ?
Or is it just to place all times from sheet2 that fall on the intervals?

Yes, times on both sheets are half hour intervals.

try the macro and press the button on sheet2