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.
Bookmarks