Hi,

I have data in A1 of workbook Test.xls which I want to find in column A of workbook Test2.xls, once found I want to return the value of H5 in Test.xls into the corresponding row in column C of Test2.xls

Both worksheets are called Sheet1 in each workbook.

Can someone let me know how I can macro this as I need to extend the same process with further data copying in the future.

Thanks.