[FONT="]I am wondering if anyone has ever used the Range.Find macro for finding a certain value storing it as a variable then looking for it again in another file.
[/FONT]
[FONT="]
[/FONT]
[FONT="]So basically there is an ID that I am trying to use as the finding variable and do this for each row. So first ID = Variable go to another workbook and look for that ID and copy two specific columns, lets say C and D then take the data within those two columns and past them in the corresponding workbook of the same row and the finding variable (ID)
[/FONT]
[FONT="]
[/FONT]
[FONT="]
[/FONT]
[FONT="]WORKBOOK 1
[/FONT]
<tbody>
</tbody>[FONT="]GO TO WORKBOOK 2, find the id in column a of another workbook
[/FONT]
<tbody>
</tbody>[FONT="]Select Title and Status of the corresponding row (B21 and C21) and then bring it back to workbook 1
[/FONT]
<tbody>
</tbody>[FONT="]Please let me know if I have lost everyone, I am not as familiar with looping which is why I hope for this to be a learning experience and for you to have pity on for asking how to create this. Thank you!!
Posted on Microsoft Community : https://answers.microsoft.com/en-us...-3610-4c13-a305-c4243426823c?tm=1562162391506[/FONT]
[/FONT]
[FONT="]
[/FONT]
[FONT="]So basically there is an ID that I am trying to use as the finding variable and do this for each row. So first ID = Variable go to another workbook and look for that ID and copy two specific columns, lets say C and D then take the data within those two columns and past them in the corresponding workbook of the same row and the finding variable (ID)
[/FONT]
[FONT="]
[/FONT]
[FONT="]
[/FONT]
[FONT="]WORKBOOK 1
[/FONT]
A | B | C | D | |
1 | ID | TITLE | STATUS | OTHER |
2 | ABC-1234 |
<tbody>
</tbody>
[/FONT]
A | B | C | D | |
20 | ID | TITLE | STATUS | OTHER |
21 | ABC-1234 | EXAMPLETITLE | STATUS1 | -------- |
<tbody>
</tbody>
[/FONT]
A | B | C | D | |
1 | ID | TITLE | STATUS | OTHER |
2 | ABC-1234 | EXAMPLETITLE | STATUS1 | -------- |
<tbody>
</tbody>
Posted on Microsoft Community : https://answers.microsoft.com/en-us...-3610-4c13-a305-c4243426823c?tm=1562162391506[/FONT]