I workbook 1 which has values in column A and data in B and C and a date in cell D1. In workbook 2 I have the same values in column A. On row 1, I have a date and then a column for comments which repeats so every second column is a date and comments as per below:

Workbook 1:

A B C D
WS8.02 Pass 18/08/2012
WS8.03 Pass
WS8.04 Fail Comment


Workbook 2:

A B C D E F G
18/08/2012 Comments 25/08/2012 Comments 01/09/2012 Comments
WS8.02 Pass
WS8.03 Pass
WS8.04 Fail Comment

I'd like a macro which will match the date and index the values in A and paste values from B & C in workbook 1 to workbook 2, I just don't know the syntax in VBA.

Thanks in advance