Hi Bob,

Thanks for that, but I can't seem to get it to work. This is probably
because the example I gave was to illustrate the problem. The actual
arrangement of my data is as follows:

Data to copy is in cells G1:BH1 on the "Data" worksheet
Date to use is in A4 on "Dates" worksheet
Date range to look up date is E7:E377 on the "Data" worksheet
Data to then be pasted in col G in row corresponding to date.

Hope this helps you to help me!

Rob