Using a cell to find a row in another workbook and copy data

[CodeRebel]

I'm hoping somebody can point me in the right direction. I know how to extract data from another workbook on a server location using VBA.

But I'm afraid what I need may be a little more advanced than my ability.

I'm currently learning VBA for my company and I have a tool that compares a lot of data from other files and makes sure they all match.

I want to be able to type in a DR #in a field below. And VBA find the last used row in column B... and use that number in the cell as a search query to find a specific row in another workbook. Then copy the entire row back into another sheet in my tool workbook. The other workbook columns are fixed so I can manage to get it to copy/paste the data into the proper fields on my own. I think...

Thanks in advanced.

 

[James006]

Hi,

To locate the last row in column B

 lastrow = ActiveSheet.Cells(Rows.Count, "B").End(xlUp).Row

 

[CodeRebel]

Hi,

To locate the last row in column B

 lastrow = ActiveSheet.Cells(Rows.Count, "B").End(xlUp).Row

Tha KS, but I was more concerned with being able to use that last row cell value to search other workbooks and copy and paste the rows from those workbooks into this workbook. All together.

 

[James006]

OK ...
But with no further details, you should adapt the following

sndwbk.Cells.Find(What:=Range("B" & lastrow) , ....

 

[CodeRebel]

OK ...
But with no further details, you should adapt the following

sndwbk.Cells.Find(What:=Range("B" & lastrow) , ....

I don't know how much detail I need to give. I don't want you to think I'm trying to get somebody to write the code for me. And I fear giving too much information might be confusing because it's just a piece of a much bigger tool.

 

[CodeRebel]

I don't know how much detail I need to give. I don't want you to think I'm trying to get somebody to write the code for me. And I fear giving too much information might be confusing because it's just a piece of a much bigger tool.

But... that helps. Thanks! I'll look into researching that code. I think it may be what I need.

 

[James006]

A pretty simple way to learn about the instruction Find ... is to turn on your macro recorder ... and hit Ctrl + F ... and go your the process once ...
You will get a "VBA translation" of your action ... which is a good starting point

 

[smozgur]

@CodeRebel - If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.