I`m having the following challenge. In my initial file there are 3 cells (for example a1,b1 and c1) named A, B and C. In the target file there are numerous letters in one column. I need to find the row containing a, b and c in the target file, and copy the value that is 2 cells to the right back into the initial file into the corresponding cell ( so the value from A next to A and so on).

I got this to work when using only 1 workbook with the following code:
in this workbook the range A1:A3 functions as "initial file" and colum C as "target file" with column D holding the value that needs to be pasted back to A1:A3. The problem is i cant get this to work when the C and D column are in another file
Please Login or Register  to view this content.