Hi,

Thanks for the code. I forgot to tell you that there are more rows of data in the "Financial Data" workbook than in the "Variance" workbook and I just want to copy across when there's a match with those fields stated in the Variance workbook.

Is this a simple modification to the code in your reply?

Best wishes,

Louise