Compare two date fields on different sheets and carry out an action.

Hi

I am trying to figure out a method of looking at two columns in different sheets and comparing the dates and then carrying out a copying action to populate a column on the RH empty column.

The problem is the first sheet has a single datetime format and the second sheet has a separate date and time column.

If there is a matching date from the first sheet (AUSUSD) in the second sheet (Announce) then i would want to copy the relative cells in columns B to E over to the first sheet into columns R to U.

The attached workbook has cells highlighted and some sample data.

Any advice on how to do this appreciated.

Regards

Neil