Find Value In Another Workbook VBA

[tlrobinson512]

Hello everyone! I am trying to find the right solution and hope my experts can help me!

What I need to do, is to reference the value in cell F3 of wkbk1 ("Metro2") and find the matching value in wkbk2 ("Preview Analysis"). From there I can add in the commands I would like carried out once that cell is found in wkbk 2.

The second piece of my puzzle is to then have this function move down to the next line in wkbk1 (i.e. cell F4) and repeat until all rows have been looped through. So I feel like I have the filling of my pie, but I am in need of the top and bottom crust!

Any thoughts on the best way to approach this? Thank you in advance for any advice.

 

[marcucciboy2]

Have a shot at these references. If they don't do anything for you, go into more specifics or try to give an exmple of what you want and I'll try to directly write some code.

Range.Find Method (Excel)

Looping Through a Range of Cells

 

[tlrobinson512]

Marcucciboy2,

Below is what I am hoping to accomplish.

I have written code that will do this function when actually manually entering in the value I wanted using the InputBox method. What I am trying to see is whether there is a way, that I can have my macro look at cell A1 (account 100), and then go to workbook 2 and find that matching value without me having to enter the value? From there I am going to extract a range of cells back to workbook #1 (that part of the code I have). But then I want the same function to repeat for cell A2 on workbook1, all the way down until there is an empty row in workbook 1. So in this case, the macro would stop after account 109 has extracted the necessary information.